Forum Discussion

Samuel Deane's avatar
Samuel Deane
Copper Contributor
Nov 18, 2018

Conditional Formatting - only the first rule works

Hi,

 

I've added basic conditional formatting to a colleague's spreadsheet, where numbers between certain percentages display as green yellow or red in a traffic light system. 

 

The conditional formatting is done correctly on both my spreadsheet and my colleague's spreadsheet to my understanding, however, it doesn't work on my colleague's spreadsheet; only the first rule (red) works. I've attached screenshots of all of the rules and how they were done. 

 

Could someone please help with any reasons as to why the exact same Conditional Formatting would work on my spreadsheet but not my colleagues?

 

Thanks in advance!

2 Replies

  • Seems like a problem i had before.. What helped me out was copying the correct working cells to the other ones. 

     

    Regards,

    DM


  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Samuel,

     

    Hard to say without the data. The only question why do you say about the percentage? Your rules are for values themselves.