Auto Coloring a Row
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 :)
|