Conditional formatting with formula
 

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?

Conditional formatting with formula
 

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


"CClark" wrote:

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?

Conditional formatting with formula
 

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

=AND(A2TODAY(),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

On Feb 26, 6:57*pm, CClark wrote:
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?

Conditional formatting with formula
 

If the cell you're on is, say, A1:
=A1<=TODAY()+30
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"CClark" wrote:

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?