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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formulas to count dates 2
Combining several cells into single equasion? 1
adding every other column 7
Combining text from several cells into 1 cell 4
'if then' color changes....................... 4
Simple calculation where values change to letters? 3
Why this formulo not working 1
RUNNING BALANCE NOT SHOWING 2

Back
Top