conditional formating

[designbyh]

Hi my name is hayley this is my first time on your forum. I have to Write a report each part of the repot needs to be done by a set date. So what I want to do is in the cell below the date I want the days to count down and when it gets within 10 days I want the font to turn red. Thank you all so much for your help.

 

[Marcílio_Lobão]

Hayley, Good morning. Suppose your date control is in D4. You can use this formula where you want obtain an color effect: =TODAY()-D4<=10 Tell us if it worked for you. Best regards, Marcílio Lobão

 

[designbyh]

This just gives me a true or false ready