• 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.

Conditional Formating on Date

E

Ecel Dumbo

Member
Hello,


I need a formula to help in doing conditional formatting for date


say for Example- Date given is 25/02/2012

When this date has only one month left to cross one year, that is,if today's date is 25/01/2013, it should turn yellow and when this date crosses one year,that is, if today's date is 25/02/2013, it should turn red.


Thanks
 
Hi,

Assuming your date is in cell A1, use these 2 formulas in conditional formatting:


=TODAY()>A1+365 (for Red)

=TODAY()>A1+365-30 (for Yellow)
 
Hi ,


If you have the Analysis Toolpak add-in installed , you can also use the EDATE function , as follows :


=TODAY()>=EDATE(Your date,11) , YELLOW


=TODAY()>=EDATE(Your date,12) , RED


Narayan
 
THanks GC Excel and Narayan for your answers.


Hi Narayan, I have not yet installed EDATE function. Will defintely look in to it. Thanks
 
Hi, I need to conditional format font and cell color with the 5 day work week rule. Can I do that in Excel 2010? I have the Analysis Pac installed.


Thanks!
 
You must log in or register to reply here.
Back
Top