Excel 07 conditional formatting

Excel Excel 2007
May 13, 2010 at 10:02:20
Specs: Windows XP
I am trying to format the cells of my sheet to change color according to todays date and the date included in the cell. I am tracking treatment plans and when they are due/expire. so, each cell contains a name and a date: ex: Jane Doe - 6/7/10 . Currently I am changing colors of the cells manually, but I know you can use conditional formatting to do it. In my example, Jane Doe's cell would be green (as today is 5/13/10) because it expires in 30 days, however June 7th, the cell color should change to red. When the tx plan is turned in the date will be changed to 9/7/10 and the color changed to yellow. How do I do that???

See More: Excel 07 conditional formatting

May 13, 2010 at 12:53:39
Post an example of your data, which cells have what data, use the PRE tags so everything lines up.



Report •
Related Solutions

Ask Question