Excel 2007 - Advanced Conditional Formatting

[ladyck3]

Below is an example of a table I'm working on....
Sorry its not pretty but you'll get the idea.



A B C D E F G H I
Done? Task # Priority Request Due By Days From Due Date Notes Requested By Owner
9/1/2011 7

So Col F is a Due date and G is a calculation to show how many days from the due date.
If the date turns to 0 or <0 what conditional formatting feature can I use to turn the entire row, A-I red (or whatever color)

I tried using the option to use a formula and did an if statement but that didn't work.

If it requires VBA for this particular thing... just tell me it needs that, you don't need to help with a code.
If it can't be done with conditional formatting then I'm jumping off this particular bus

I've tried a few things but nothing is working so I bow to the Gurus here for help

Thanks SO very much, and as always I am forever in your debt.

Laurie


LadyCK3
aka: Laurie

 

[Gavona]

I tried using the option to use a formula and did an if statement but that didn't work.

This was indeed the right approach. If you post the formula you tried we can advise where you went wrong. At a guess you needed to pay close attention to the absolute addresses:
Highlight the range with A1 as the active cell and the formula would be $F1<=0. There should be no other dollar signs.

Gavin