ExcelBanter - conditional format depending on time

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - conditional format depending on time (https://www.excelbanter.com/excel-programming/283131-conditional-format-depending-time.html)

arne

conditional format depending on time

in range c2:g:20 I have numbers and text and I want to
change cell colors automatically depending on the time:
If current time is between 5PM-6PM then black, 6pm-7pm red, 7PM-8PM green
and if between 8pm-9pm yellow.

Is it possible?

All times are GMT +1. The time now is 12:02 AM.