Changing a cell color automatically based on a 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?
 
F

Frank Kabel

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
 
B

Bob Phillips

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)
 
Top