Conditional Formatting

HI

I am trying to use Conditional formatting to highlight when an Expiry Date is in the next 45 Days, 50 day and 60 Days and have them all different colours.

i.e. 45 Days would be Red and 55 Days would be Yellow etc...

Any help would be appreciated.


thanks

Answers