Hi all,

I'm trying to conditional format a cell with a date in to change colour the closer it gets to the deadline from todays date.
For example, I have 2 weeks to go before a deadline - cell colour green.
1 week to go - cell colour yellow
3 days to go - cell colour orange
1 day to go - cell colour red
etc.

Any help would be appreciated.
Thanks,

Paul.