Color cell if today date is bigger by 6 than reference date cell

Data expirare culoare.jpg

Hello all,

I have solved my first tasck thanks to you.

Now i am wondering how to collor cell B4 with a specified color conditioned by one thing:

if B2 is a date lower with 6 days than the A2 cell wich is today date --> collor my cell with blue collor


Tx

Hi alexx

Try this in the conditional format for cell B4

Please Login or Register  to view this content.

Thank you very much. Bless you!