First try and conditional formatting in Excel 1

[netrusher]

I am trying my first try at conditional formatting in Excel
2003. I have a spread sheet with 6 columns and my information
starts on row 4. If Column C has a number greater than
0 in it I want Column A,B,C,D,E,F to turn green. I can
make it happen in one column. How to I make it happen
for all columns and how do I then make it happen for each
row?

Thanks for all help.

 

[bluedragon2]

Highlite all rows an columns you want formated.

In the conditional formatting options choose formula is:

=$E1>0

and format accordingly


[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[netrusher]

Perfect Blue Dragon and thanks for the help!