Cell formula to change text based on date

RW92

New member
Joined
Oct 15, 2014
Messages
1
Reaction score
0
Points
0
Hi,


I need a formula that will turn the text in a cell red after a certain number of weeks from the date entered in the cell. For example if I enter the date 15/10/14, after 10 weeks I need it to turn red.




Any help appreciated!


Excel 2007


Thanks.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try conditional format rule formula:

=TODAY()>=$A1+70

where A1 is topmost cell in your selection.
 
Top