Highlight cell if date is greater than SPECIFIC date

[Mike_Dont_Know_Excel]

Hello,
I'm having a hard time finding the right formula for what I need to do.
I need the cell to turn RED if the date in that cell is more than 10 days from the date on another cell.
Example: a date will be inputted in cell C3, then another date will be inputted in cell E3. If the date on cell E3 is 10 days or more from the date in cell C3, i would like the E3 cell to turn RED. I need that on the C and E colum.

I hope that makes sense.

Thank you very much

 

[MARK858]

If it is just the 2 cells then the conditional formatting formula is just....

=$E$3>$C$3+10

if you need it for the other cells in the columns then

=$E3>$C3+10

 

[Mike_Dont_Know_Excel]

It didn't work

 

[MARK858]

Works fine for me. Explain the steps you took.

 

[Mike_Dont_Know_Excel]

Well, maybe I dont know what Im doing. Which im 1000% sure I don't. I just copied that formula inton cell E3 and nothing happens. I need it to turn the cell red if the date is more than 10 days from C3

 

[MARK858]

You need to use put the formula in conditional formatting... see the link below

https://exceljet.net/conditional-formatting-with-formulas

and attached is a file with it working (please note that my dates are in dd/mm/yyyy format so you might need to retype them if you are in mm/dd/yyyy)

https://app.box.com/s/18db4i9zu5l6n5a0xo9q3by0xf4mn64q