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 :)
LVL 2
RossAsked:
Who is Participating?
 
royhsiaoCommented:
You should be able to use 3 conditional formatting rules to get that done.
Please see the attached pic.
conditional-time.JPG
0
 
royhsiaoCommented:
You could set the 1st rule between 00:00 and 07:59
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?
0
 
cb1393Commented:
See attached example of conditional formatting.


time-formatting.xlsx
0
 
RossAuthor Commented:
sorry for the delay - I was away from work for a while.

Exactly what I was looking for - thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.