Conditional Formatting based on current time

[ireland87]

Hi

I need to have some conditional formatting based on the current time

Say A1 contains 07:00

I'd like the formatting to be green if 07:00
Orange when its 07:15
Red after 07:30

is there any way to make it flash red after 07:30 as well?

many thanks

 

[Special-K99]

Unclear.

You say you want the conditional formatting based on the current time but then you say the formatting is dependent on A1 ???
A1 will not update unless performed by VBA or manual refresh of the spreadsheet.

07:00 is 07:00 and ZERO seconds.

So "I'd like the formatting to be green if 07:00" will stay green for one second.
This is probably not what you want.

I presume what you mean is between 07:00:00 and 07:14:59 you want it to be green
Orange between 07:15:00 and 07:29:59
and red when it's 07:30:00 and after

Yes?

Select a cell to highlight

Conditional Formatting
New Rule
Use a formula to determine... (3 needed, one for each colour)

=TEXT(NOW(),"hh:mm")>"07:00" format as green
=TEXT(NOW(),"hh:mm")>"07:15" format as red
=TEXT(NOW(),"hh:mm")>"07:30" format as orange