Conditional formatting with formula

  • Thread starter Thread starter CClark
  • Start date Start date
C

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?
 
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
 
Back
Top