Forum Discussion
Solved
Conditional formatting multiple values in a single column
I have a table that has a column with three values - Red, Amber, Green. I want to colour the cells in the table to match the words. I have tried "Field Value" dialog in Conditional Formatting, bu...
Found the solution. I was pointing the conditional formatting to the column rather than the measure..
Hi kennoe
Do you use a measure or a calculated column?
Could you show me your screenshot about the table and formula, also the setting page of conditional formatting?
Best Regards
maggie
Maggie
I used a measure. Refer screenshot.
I have set up the conditional formatting as shown below.