Ross
asked on
ms excel 2007 conditional formatting based on time of day
I have a column with times in - I'm struggling to conditionally format them based on the time thats in them. I simply want those times that are between 08:00 and 18:00 to be formatted as green, and all other times to be formatted as red.
How can I do this?
Thanks :)
How can I do this?
Thanks :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorry for the delay - I was away from work for a while.
Exactly what I was looking for - thanks!
Exactly what I was looking for - thanks!
You could set the 2nd rule between 08:00 and 18:00
You could set the 3rd rule between 18:01 and 23:59
Will this help?