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 :)