DATES IN EXCEL

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

Guest

I WANT A DATE TO BECOME YELLOW 31 DAYS PRIOR TODAYS DATE AND THEN WHEN IT
REACHES TODAYS DATE I WANT THE CELL TO CHANGE TO RED.
THE CELLS THAT I AM USING ARE C1,D1,E1,F1,G1 H1 THROUGH TO
C110,D110,E110,F110,G110,H110
PLEASE HELP!!!!
 
Select the cells
Format>Conditional Formatting
Change Condition 1 to Formula Is
add a formula of =AND(A1<TODAY(),A1>TODAY()-31)
Click Format
Select Pattern
Select yellow
OK
Click Add Condition

Change Condition 1 to Formula Is
add a formula of =A1>=TODAY()
Click Format
Select Pattern
Select red
OK
OK

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top