HELP with conditional formatting and a max time
I have a spreadsheet that I am trying to get 8 cells to conditional format
based on the "highest" condition of one cell. I got 2 of the three conditions
to format but I can't get the "middle" condition to work. Here is what I have:
=MAX($C$5:$C$8)=0.833333333333333 this turns all 8 cells "GREEN"
="MAX($C$5:$C$8)<0.833333333333333" this is suppose to turn all 8 cells
"YELLOW" but this one does not work
="MAX($C$5:$C$8)<0.791666666666667" this turns all 8 cells "RED"
I have drop downs in the cells to pick "times" and based on the lastest time
it determines the "Color" of all cells. If any of the cells, c5-c8, are 8pm
or later all cells are green. If the latestYS1107 time is 7pm or 730pm then I
want all cells to be yellow and if all cells are 630pm or earlier then all
cells red.
I hope this is clear enough, but I don't fully understand excel but I could
use some help. Thanks in advance!
|