"ALL" rows?

CTRL + a(twice in 2003) to select every row of the sheet.

FormatCF and enter the 2 conditions as you were shown.

Make sure you use =$G1="Pass" for condition1 and =$G1="Fail" for
condition2

NOTE the $ sign to lock column G but not the row number.

I think formatting the entire sheet is a bit much. Perhaps you could
select cells A1:X500 or somesuch range.


Gord Dibben MS Excel MVP


On Tue, 10 Jan 2006 12:50:03 -0800, "chhanson"
wrote:

Hey guys none of this helped all that much :S

The entire Column of "G" needs to have this rule applied for ALL rows.
The code you guys gave me is per row capable only.

Is there a wild card I can use? ex =$G*="Pass"

or a way to apply the rule of Column "G" coloring each row to the whole
worksheet?

"David Billigmeier" wrote:

1) With A1 selected, Go into <Format<Conditional Formatting
2) Choose "Formula Is" in the drop down box and enter =$G1="Pass", and
choose a green format
3) Choose to add a condition (by pressing "Add"), choose "Formula Is" in
the drop down box again, and enter =$G1="Fail", and choose a red format.
4) Click OK
5) Select A1 and copy the formatting across every column, and down every row
you would like this formatting to occur.

Does that help?
--
Regards,
Dave


"chhanson" wrote:

Hey I have set up Excel with a Drop down option through-out Column G.

If column G = 'Pass' I want that whole row to be Font.Color = Green
If column G = 'Fail' I want the whole row to be Font.Color = Red

How can I get this to occur automatically?

I get all lost not knowing all the functions and parameters that excell uses.

Please help me with this :)