T Todd Michaels Feb 10, 2004 #1 Can a cell change color when the date in the cell gets to be seven days before the system or date in excel?
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 Feb 10, 2004 #2 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
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 Feb 10, 2004 #3 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)
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)
