Hello guys,
I have the following problem: I have to conditionally format certain values based on values in another coloumn (see Excel sheet for details). I need a traffic light system: if the value in coloumn B is zero then this is the condition
green yellow red
<= 15 >15 <=22 > 22
If the value is 30, then
green yellow red
<= 30 >30 <=37 > 37
and so on.
Basically, I have to have several conditional formats for the same cell, so that when I order the table based on another coloumn, the formatting stays true.
Any help will be appreciated!
Bookmarks