Conditional formatting with formula

[CClark]

What formula would I use if I wanted to format a cell (say in red) if the
date entered in that cell is 30 days or less from today's date?

 

[Ron@Buy]

Try:
=AND(A10<TODAY(),A10>=TODAY()-30)

 

[Pete_UK]

Suppose that cell is A2, then you would use this formula:

=AND(A2>TODAY(),A2<TODAY()+31)

So if A2 is after today AND less than 31 days hence, then the CF will
be activated - I think that is what you meant.

Hope this helps.

Pete

 

[KC hotmail com>]

If the cell you're on is, say, A1:
=A1<=TODAY()+30