rskip
New Member
- Joined
- Nov 26, 2009
- Messages
- 38
- Office Version
- 365
- Platform
- Windows
I have a cell for current time (C4) (Pressing F9 to refresh, and a list of times, 01:00, 02:00, 03:00 etc.(C10, C11, C12) I want to turn the the cells with a static time (01:00, 02:00 etc) red when the time passes, I have conditional formatted the cells C10, C11, C12 with =C10<C4 (RED) etc. However they do not turn Red. In Google sheets this works, however not in excel.
Thoughts on what is wrong?
Thanks
Thoughts on what is wrong?
Thanks