-
Field ID - Select the Choice cell’s cell ID.
-
Use Value - Enter the choice option’s label you want the selected cell to get its formatting from.
In the example above, Closed is formatted to have a red background and white text. The selected cell will have a red background and white text.
If you want the selected cell to be formatted like the choice option only when the specified choice option is chosen, enter the following formula in the Use Value box:
For example:
=IF(Choice2="Closed","Closed","")
The selected cell will only have a red background and white text when Closed is selected.