Select the entire row or a range of cells across that row, say A1:L1

FormatCFFormula is: =$A$1=0

The row or range of cells will turn color if A1 is = to 0

Note the $ signs which fix A1 as the trigger cell.

If doing a bunch of rows at the same time, say A1:L50 the formula would read

=$A1=0 which fixes the column but not the row.


Gord Dibben MS Excel MVP


On Wed, 21 Mar 2007 11:28:03 -0700, jostlund
wrote:

How would I apply conditional formatting to a row if cell = 0, and not just
to the cell?