Hi All,
I am trying to use a 3 colour scale for my sales value using conditional formatting, however all of them appear as the same colour.
Please see attached - I am trying to change the colours based on the values in column C.
ConditionalFormatting_3Colour.xlsx
Can I also ask, is there a way to define the colour scales based on the level (see column A) - if level 1, sales above 150 should be in red while for level 2, sales above 100 should already be red.
Thanks All!
Bookmarks