Help with conditional formatting

  • Thread starter Thread starter Chance
  • Start date Start date
C

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.
 
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
 
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
 
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
 
Back
Top