Forum Discussion
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.
Perfect. Thank you!!
