Forum Discussion
Conditional formatting? highlight a cell based on current time
- Dec 16, 2021
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.
Of all the answers and suggestions, You are THE VERY BEST for breaking it down to 30 min intervals. Now, if A (H in your example) is the first column showing the time, and I have other data in other columns up to column Z, how do I make this conditional formatting highlight the entire row from, for example A35 to Z35? Thank you in anticipation and in advance 😜🤗