Solved Excel 2007 conditional format cell based on time value

June 30, 2012 at 07:11:03
Specs: Windows 7
Hi - I have a cell that is calculated based on 2 other cells
=IF(F2="","",TEXT(F2-C2,"h:mm"))
What I am trying to do is get the cell G2 to change colour if the time is => 4 hours. I have read for hours but everything suggested does not appear to work
Does anyone have any ideas of how I can do this?

See More: Excel 2007 conditional format cell based on time value

Report •


#1
June 30, 2012 at 17:38:34
✔ Best Answer
I am assuming that the formula you posted is in G2.

I am also assuming that you have entered a time value in F2 and C2.

If that's the case, then this CF Rule on G2 should work:

=HOUR(G2)>=4

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question