Changing a cell color automatically based on a date

  • Thread starter Thread starter Todd Michaels
  • Start date Start date
T

Todd Michaels

Can a cell change color when the date in the cell gets to be seven
days before the system or date in excel?
 
Hi Todd
select your cell and goto 'Format - Conditional Format'. Enter the
following formula (if you selected cell A1):
=A1=TODAY()-7
if you want to highlight all dates between today and today-7 try
=AND(A1>=TODAY()-7,A1<=TODAY())

Frank
 
With conditional formatting, and a formula (Condition 1 - Formula Is) of
=TODAY()-7<=A1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Conditional Formating based on Date 5
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Automatically change cell colors based on date in cell 1
Conditional formatting 1
Conditional Formatting based on a due date 2
Excel Macro to automatically go to the right of the last colored cell 0
Change the color of a cell 7
Conditional Formats Date Based 1

Back
Top