Conditional Formating not applying properly

[Beastwood]

Hy everyone,

I have a document i'm working on atm, with time frames conditions set to lines, but something seems not to work properly when the conditions start to apply, for some reason only the first cell changes color .

Attached is Hours-test.xlsx

Please take a look if possible . Thanks in advance.

B.

[Kaper]

You shall use different adressing modes depending on a desired result. For instance mixed adressing shall be used for gray "too early" CF formula (relative row, absolute column):

Please Login or Register  to view this content.

then in all cells in current row (in this case 16) value from column A and current row is used in calculations.