Conditional Formatting based on 2 Criteria

Hi guys. I am struggling a bit trying to get my conditional formatting to work. I am using Excel 07. I was attempting to use the Conditional Formatting tool with little success.

I have 2 columns I need to consider.

First Column (V) - Contains Target Date
Second column (K) - contains Percent Complete

I need to turn Column V cells a certain color based on 2 criteria. Anything that has a percentage of 95% (column K) or above should just be green and the rule should stop there.

However, anything that is less then 95% (column K) I want to assign the following criteria for the Cell Color (column V).

RED = 5 days from todays date or expired
Yellow = 6 to 10 days from todays date
Green = +10 days

First priority is just to get color formatting correct based on the date. If I have to I can just filter by the other column that contains the percent manually that is fine. The auto shading everything based on the other column (%) is just a nice to have but not essential.

Any help would be greatly appreciated. I have been really struggling with this.

I got the cells to turn green but it highlighted everything green. The yellow and Red did not show up at all.

The UI is different in Excel 2007. When you click on Conditional formatting it gives you the option to select New Rule. From what I understand the equivalent of "Formula Is" in the new version is selecting the rule type "Use a Formula to determine which cells to format".

Then you get Rule Description box that says "Format values where this formula is true". So I put in the formulas as you had them and got the results above.

There is another option when selecting the Rule type called "Format all Cells based on their values". Then you select 3 color scale and it gives you 3 parameters.

Minimum - Type (Lowest Value, Number, Percent, formula, Percentiles) - You select one. Value - Select Cells. Color - Select Color
Midpoint - Same
Maximum - Same.