I am trying to get a cell 'Target Date' to change from green to amber to red as the days countdown towards that date.
As the days count down cell format is green when there is still 20 days still to go. Changes to amber when only 10 days to go and red when only five days to go.
When a date is entered into 'Completion Date' cell, the count stops and the colour of the 'Target Date' cell stays as is based on the number of days passed when the 'Completion Date' cell had a date entered.
Here is what I have written, but doesn't work for the green formatting
=IF($G$8 -TODAY(),"",IF($G$8-TODAY(),"DAYS>=20", "False"))
As the days count down cell format is green when there is still 20 days still to go. Changes to amber when only 10 days to go and red when only five days to go.
When a date is entered into 'Completion Date' cell, the count stops and the colour of the 'Target Date' cell stays as is based on the number of days passed when the 'Completion Date' cell had a date entered.
Here is what I have written, but doesn't work for the green formatting
=IF($G$8 -TODAY(),"",IF($G$8-TODAY(),"DAYS>=20", "False"))