Conditional Formatting
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?
|