Highlighting cells in 20 minute increments.

[Holmes89]

I would like cell IJK3 highlight itself at 20:00 then IJK4 become highlighted at 20:20 and for IJK3 to go back to being not highlighted at 20:20. At 20:40 I would like IJK5 to become highlighted then IJK4 to go back to being not highlighted. At 21:00 I would like for IJK6 to be highlighted and IJK5 not to be anymore then at 21:20 I would like IJK3 to go back to being highlighted. I need a formula to be able to do this.

 

[Anthony47]

You might set a conditional format on UK3 using the formula =INT(MINUTE(NOW())/20)=0
You shall use =1 and =2 fot the other two cells

However this will recalculate whenever there is a Calculation in the worksheet, so if nothing happens the format will not change. If you need it keep updating by itself you need to add a OnTime macro that update the sheet every XX seconds /Minutes