• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help Setting Days Reminder

B

buster

New Member
I am in the Army. Currently, I am attempting to build an excel sheet that will allow me to highlight dates that are at 30, 60, and 90 days out from the current date. can anyone provide me the formula and instructions. I would like to be able to be able to have the 30 days in red, 60 days in orange, and 90 days in yellow. Please help.
 
Select the cells of interest (I'll assume A2 is the active cell), then go to Conditional format, formula1 is

=TODAY()+90>=A2

Format yellow


formula 2

=TODAY()+60>=A2

Format orange


formula 3

=TODAY()+30>=A2

Format red


Thank you for your service. =)
 
sure thing. Home Tab, Conditional format, new rule, use a formula.

=TODAY()+90>=A2

Format yellow


Repeat for the other 2 formulas and formats.
 
You must log in or register to reply here.
Back
Top