Conditional Formatting for Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to condidtionally format dates that when the
date is within 30 days of an end date (5/30/04)it turns
red, and if it is within 60 days of the date it turns
green.

Please help.

Thanks

CJ
 
For the first condition (formula is)

=cell_with_05/30/04-cell_date<=30

add a second formula is condition

=cell_with_05/30/04-cell_date<=60

what if the date is later than 05/30/04?

If you not want 05/31/04 to be displayed in red

=AND(cell_with_05/30/04>=cell_date,cell_with_05/30/04-cell_date<=30)

do the same for the second condition
 
Hi

Put your End Date in a cell (say A1) and use it as a reference:
=A1-A2<30 (for cell A2) and set Pattern to Red
=A1-A2<60 and set Pattern to Green
 
I have tried this formula, but I cannot get the second
condition to work, I have no idea of what I am doing
wrong.

The first condition is =$AF$22-$B$1<30 should be Red


Second is =$AF$16-$B$1>31 should be green

$B$1 is todays date and $AF$ is the end date of the
contract.
 
Back
Top