Conditional Formatting

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I'd like the conditional formatting to look at all the
cells on a worksheet, if a cell has a -1 in it, I'd like
the row to become bold and gray. Is there a way to write
this in the Conditional Formatting menu? (I'm using Excel
2000)

Thanks all!
 
I selected the whole range (whole worksheet???) and with activecell in row 1, I
used this formula within the Conditional formatting "formula is" box:

=COUNTIF(1:1,-1)

Excel will adjust it for each row.

If it was just a few columns, I had to be more careful:

With the activecell in row 1, (but my whole range A1:L9999 for me selected), I
used this formula:

=COUNTIF($A1:$L1,-1)

(the $'s are important.)
 
Back
Top