Help with conditional formatting

[Chance]

If I'm using columns a-j and column "g" has the criteria
that i'm looking for, which is 0. How can I turn the font
on a thru j on that row to red and keep on repeating down
the rows.

 

[Dan E]

Select the Range of interest (ie A1 to G100) or however many rows
"Format" -> "Conditional Formatting"
for your condition select "Formula Is" and put "=$G1=0" without quotes
set your format and select OK

Dan E

 

[Chance]

That works great but why does the first row with my
headings also change color. Is there a way to format A:J
and not format row 1

 

[Dave Peterson]

If your "range of interest" starts in row 2, then you'll have to adjust the
formula.
=$G1=0
becomes
=$G2=0
(if your active cell is in row 2)

If you select A99:G12456 and your active cell is A99, then it would be:
=$G99=0