Forum Discussion
Conditional formatting? highlight a cell based on current time
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.
6:00 AM
6:30 AM
7:00 AM
7:30 AM
you can use this formula: =AND(HOUR(H2)=HOUR(NOW()),MINUTE(H2)=(IF(MINUTE(NOW())<30,0,30))).
It's the same formula provided by Hans with addition checking minute of the listed hour column, whether 0 or 30.
Najmi6240, thank you this was very helpful, just want to share with others that if you are working with 15-minute increments you can simply change the 30 in this formula to 15.
Peaceful82 Hello, I've tried this on mine and it only highlights at o'clock and quarter past, is there a way to also get it to highlight at half past and quarter to?
thanks
See the attached demo workbook.
