Conditional Formatting Equation

[RLJ]

I need an equation for some conditional formatting. I want an equation to format a cell if the the adjacent cell is within 5 days of the date in the cell.

Ex: in Cell E2, I want it colored if the value in F2 is within 5 days of the date entered into the cell. So if the date is 5/24/2011, I want the cell E2 to be colored until 5/30/2011.

 

[VoG]

Try the CF formula

=AND(F2>E2,F2-E2<=5)

 

[RLJ]

It is not working because I do not have a date in E2, just text. I want to just see if the data in cell e2 has been updated within the last 5 days from the date in f2.

 

[VoG]

Try

=AND(F2>TODAY(),F2-TODAY()<=5)

 

[RLJ]

Looks like this should work.
=AND(F8>=TODAY(),F8-TODAY()<=5)

Thanks

 

[RLJ]

It looks like the equation is not working. I opened the spreadsheet today and everything with a date of 5/24/2011 is not highlighted anymore.