Forum Discussion
use conditional formatting with time
how to use conditional formatting with time,
If cell B is greater than 09:02:00 AM it should be highlighted in yellow,
waiting best response
Date
Time
Remarks
1-Feb-18 ...
SergeiBaklan Thank you for the quick response. I am an excel newbie and having a hard time understanding how you got that to work, what is this formula actually saying? The 59/24/60/60 part
I am using a custom format for these cells of hh:mm:ss , does that matter? I want cells that reflect HIGHER than 00:01:00 (greater than a minute) to be red and cells that are EQUAL TO OR LOWER than 00:00:59 to be Green (less than a minute)
Format doesn't matter, it's only the way to show the number, not to change it.
Here
is exactly the same number to which are applied different formats.
On your screenshot color for two cells with value more than 59s is changed. Same is here:
Which result do you expect?
