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

The only way I know to do it is by placing a conditional format within each
cell, unless you had a macro do it automatically. I might could help you
better if I knew exactly what you wanted to accomplish. However, based on
your example, I am going to use A1 as the cell that equals 0 and row 1 as the
row you wish to apply the condition to. Not knowing how far down the row you
need the condition, I will say from A1:M1. In each cell (A1:M1) place the
below formula:

=AND($A$1<"",$A$1=0)

Make sure you indicate "Formula Is" in condtion.

Les
"jostlund" wrote:

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

That does it! Thanks very much.

"WLMPilot" wrote:

The only way I know to do it is by placing a conditional format within each
cell, unless you had a macro do it automatically. I might could help you
better if I knew exactly what you wanted to accomplish. However, based on
your example, I am going to use A1 as the cell that equals 0 and row 1 as the
row you wish to apply the condition to. Not knowing how far down the row you
need the condition, I will say from A1:M1. In each cell (A1:M1) place the
below formula:

=AND($A$1<"",$A$1=0)

Make sure you indicate "Formula Is" in condtion.

Les
"jostlund" wrote:

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

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?

Much easier - thanks!


"Gord Dibben" wrote:

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?