Formula HELP

hissini

New member
Joined
Mar 31, 2014
Messages
1
Reaction score
0
Points
0
I need a formula that will automatically highlight a cell as well as write the word "RUSH" when a date is typed in that is within 2 weeks of the current date.

Thank you!!
 

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
Assuming the dates start in A2, then in B2 enter formula:

=IF(AND(A2-TODAY()>0,A2-TODAY()<=14),"RUSH","")

For highlighting the cell, select the column. Go to Home|Conditional Formatting, then select Use a formula to determine which cells to format.

Then enter formula: =$B1="RUSH" (where B1 is top most cell in column you selected and contains the above IF() formula)

Click Format and choose colour from Fill tab.
 
Top