Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Conditional Formatting
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Conditional Formatting
Excel Dumbo expressed precisely :
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 That will require setting 2 conditions. I don't see any point in setting a condition if the date is less than 1 year, and so I suggest setting CF to handle only if the date crosses one year. If you need a visual indicator )other than the default fill color) that the date hasn't crossed yet then you can manually set fill color for the range. If you want to *flag* a date that's about to cross a year (last day) then set its CF condition 1st, set the other one last... For flagging last day before crossing (yellow) =($A1+365)=TODAY() For crossing the year (red) =(TODAY()-366)=$A1 ...where the number of days (365/366) account for 2012 being a leap. Adjust this to your liking.<g -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
conditional formatting a date | Excel Discussion (Misc queries) | |||
Conditional Formatting by date | Excel Discussion (Misc queries) | |||
date conditional formatting? | New Users to Excel | |||
conditional DATE formatting? | Excel Discussion (Misc queries) |