How do i highlight whether a date is upcoming

Microsoft Excel 2003 (full product)
January 17, 2011 at 20:30:58
Specs: Windows XP
I have a spreadsheet with dates activites are due to be done. I am looking to have the dates occuring in the next 14 days to be highlighted green and anything further in the future to be highlighted yellow.

See More: How do i highlight whether a date is upcoming

Report •


#1
January 18, 2011 at 06:03:51
Look up Conditional Formatting in Excel help or Google it.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question