Excel 2007 : Excel formatting help

**brentpresley85** · 11-30-2010, 06:53 PM

I have an excel sheet that I need to set to format. in column A i have truck #'s and in Column B I have due dates for a certain service, like an oil change. I want to set excel to color code these, i.e. if 45 days or more past due to be one color, 1-44 days past due another color. if they will be due or past due within 30 days another color and if non of these criteria no color. can someone explain how to set this up? thanks!

**Paul** · 11-30-2010, 11:46 PM

Hi Brent, welcome to the forum.

Here's a basic example of using conditional formats to highlight due dates. It's shown in Excel 2003 or previous, but the same principal applies (using formulas to create formats).

http://www.mrexcel.com/articles/due-...formatting.php

In Excel 2007, though, you can have more than three conditions, which is nice. Hope that helps!