Cell Color change

[kscheckel]

Hello All

Excel 2010

I am trying to color change due date

I want 10 days from due date to be green

5 days from due date yellow

Due date and after Red

however, when product is shipped from a date in a different cell I want the due date cell to be white again


Is this possible? thank you for your help

 

[Luke M]

Assuming due date is in B2, ship date will be in C2.

Formula 1:

=AND(ISBLANK(C2),TODAY()=B2)

Format red


Foirmula 2:

=AND(ISBLANK(C2),TODAY()+5>=B2)

Format yellow


Formula 3:

=AND(ISBLANK(C2),TODAY()+10>=B2)

Format green

 

[kscheckel]

Thank you for the information