Excel VBA code to automatically change colour shape based on time

Hi,

I am total newbie to excel vba and I am working on a project in which in which I have change the shape colour based on the time for example if it is midnight the shape color should be yellow and if it is 6 O'Clock in the morning the shape colour should be green etc.

The number of shape that I have to work with are about 14 and I have been trying my level best to figure out how to put the time interval in the excel and vba to so that it should work but to not avail.

I attached a worksheet with the shapes

The information on the second sheet ("picture") is currently maniplating the colour of the shapes but I want to merge the time into the if loop so that time can control the colour of the shapes while other will only display what is the value of the shape.


If anyone can help me with this i would appreciate it a lot.

Thank you,