Greater Than - Conditional Formatting - Multiple Cells - Excel 2007

[akrshaw]

Is there any way to setup conditional formatting across multiple cells without having to do each individual one?

I have a budget spreadsheet like this:

Role [tab] [tab][tab] [tab] Resource [tab] [tab][tab] [tab] [tab][tab] [tab] Aug 20 [tab] Aug 27 [tab] Sept 3
Solution Leader [tab] John Doe [tab] Estimated Hours [tab] 23 [tab] [tab] 23 [tab][tab] [tab] 40
[tab][tab][tab] [tab] [tab][tab] [tab][tab] [tab][tab][tab] Actual Hours [tab] [tab] 8 [tab] [tab] 16 [tab][tab] [tab] 34

My goal is that if the actual hours are greater than the estimated hours they will show red.

I have about 20 resources and 32 weeks to do....going through and formatting each one will be too time consuming.

Any help in doing this funtion enmass, would be greatly appreciated!~

Thanks

 

[SkipVought]

hi,

1) select ALL the cell that you want CFed.

2) Home > Conditional Formatting > NEW RULE -- Use formula to determint which cells to format

3) The FORMULAS that you will use will ALL be relative to the UPPER LEFT CELL of the selected CF range.

So lets suppose that the upper left cell of the selected CF range is D2, which is the John Doe Estimated Hours for Aug 20. Your formula IN THAT CELL should 'say' that
[tt]
when [C2 ([highlight]the hours definition COLUMN[/highlight]) = "Actual Hours"] AND [D2 > D1], SHOW RED
=And([highlight]$[/highlight]C2="Actual Hours",D2>D1) --- Assign a RED format
[/tt]
This will propagate the CF thru the entire range.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]