Formula only works on first cell specified in range (AGAIN!)

Hello everyone,

I asked an original question here, it was answered, but i wanted an easier way then copy and pasting a formula 365 times, so i learnt how to do relative pasting, but the formula for it brought back my original problem. I did ask on the original post, but it was swampped by then. Here is the original post for referal.

So this is the code I worked out to get it to as i copy the formula down on the overview, move the selection of cells it is testing across.

Formula

Please Login or Register  to view this content.

(Font)
Applies to

Please Login or Register  to view this content.

But now i have my original problem, i have all days highlighting in the month that i have done (January) but if i choose any time slot other then 00:00 it won't register, what have i done wrong ?

What is the formula supposed to do? Where is it supposed to be? what are your expected results?

Try this as the formula for the conditional formatting rule for the month of January:

Formula:

Please Login or Register  to view this content.

Notice that there are two commas inside the INDEX function. This is because the days on the January sheet are laid out in columns not rows, and the third argument of INDEX is for columns.
Let us know if you have any questions.

All I did was to select the range A2:D32 on the 'Overlook' sheet > open conditional formatting > manage attachments > edit rules > pasted the formula into the window.
Attached is a copy of the file with the conditional formatting formula applied.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.