Forum Discussion
Solved
Conditional formatting? highlight a cell based on current time
Working on an hourly To-Do list. I have a column (H) with the listed hour (on the Hr) starting with 5am all the way until 11pm. For Example: 6:00 AM 7:00 AM 8:00 AM 9:00 AM The ask: I would ...
Let's say the times are in H2:H20.
Select this range. H2 should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to detemine which cells to format'.
Enter the formula
=HOUR(H2)=HOUR(NOW())
(Remember, H2 is the active cell in the selection).
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Hi all,
I have created a digi clock on an excel sheet and am trying to work out the conditioning formatting to change the cell colour if the time passes. e.g if the departure time is 12:00 then the cell D15 changes red at 12:01 (my digi clock is set up HH:MM:SS)