View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default 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?