Help with dates

  • Thread starter Thread starter Looping through
  • Start date Start date
L

Looping through

Does anyone out there have a formula that looks at cell (H5) in which it
contains a date (mm/dd/yy) and returns a 1 if the date is older than 30days
from today or 0 is false? Or better yet conditionally format the cell (H5) in
Red if older than 30 days from today.

TIA
Peter
 
To apply the conditional formatting, select H5 then click on Format |
Conditional Formatting, then choose Formula Is rather than Cell Value Is in
the first box and put this formula in the next box:

=TODAY()-H5>30

Then click the Format button, select the Patterns tab (for background
colour) and choose red. Click OK twice to exit the dialogue box.

Hope this helps.

Pete
 
Back
Top