Forum Discussion
Solved
Conditional Formatting rules on cell value
Hi there, I have a table with [Country], [Score] and [Difference]. The [Difference] column contains only -1, 0 and 1. If the Score is higher than the previous year it holds a 1, if it's the same th...
Hi JemmaD , You could use conditional formating please try these
Apply Conditional Formatting:
- Select [Score] in the table visual.
- Go to Conditional Formatting > Icons and set rules:
- 1→ Up Arrow (green).
- 0→ Neutral Arrow (yellow).
- -1→ Down Arrow (red).
Remove [Difference] from the Visual:
Conditional formatting will still work even if [Difference] is not visible.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi JemmaD , You could use conditional formating please try these
Apply Conditional Formatting:
- Select [Score] in the table visual.
- Go to Conditional Formatting > Icons and set rules:
- 1→ Up Arrow (green).
- 0→ Neutral Arrow (yellow).
- -1→ Down Arrow (red).
Remove [Difference] from the Visual:
Conditional formatting will still work even if [Difference] is not visible.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi Akash_Varuna
I'm afraid that is what I am reporting as not being able to do.
This is what I have in conditional formatting:
It won't let me change 'First Difference' to anything else.
This is the result when Difference is in the table:
This is the result when I take it out:
