G
Guest
How would I apply conditional formatting to a row if cell = 0, and not just
to the cell?
to the cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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
G
Guest
That does it! Thanks very much.
WLMPilot said: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
G
Gord Dibben
Select the entire row or a range of cells across that row, say A1:L1
Format>CF>Formula 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
Format>CF>Formula 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
G
Guest
Much easier - thanks!
Gord Dibben said:Select the entire row or a range of cells across that row, say A1:L1
Format>CF>Formula 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