Hi Everyone,
Im trying to write what should be a really simple conditional format but this is driving me insane!
All I want is for rows A-F to turn a colour if the time in column C equals midnight (0:00).
As I little knowledge of the time function I started by writing a standard if statement in a nearby cell:-
=IF(C7=TIME(0,0,0),"yes","no")
I then tried to turn that into the conditional format, but Im going wrong somewhere!
=IF(C7=TIME(0,0,0)
please could you help before something awful happens to my laptop?!
Thanks
kind regards
Alex
Bookmarks