Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a conditional formatting with the following criterion: all cell that will be equal the zero (0) will be formatted with yellow
source and red fulfilling. But all time that the cell is empty the formatting is equal the zero
formatting (0). How I make so that the cell is not formatted when the cell will be
empty? The cell with equal value the zero (0) will be formatted. The empty cell will not be formatted.
 
Lyco,

You could try this

=AND(A1<>"",A1=0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

lyco said:
I want to make a conditional formatting with the following criterion: all
Click to expand...
cell that will be equal the zero (0) will be formatted with yellow
source and red fulfilling. But all time that the cell is empty the formatting is equal the zero
formatting (0). How I make so that the cell is not formatted when the cell will be
empty? The cell with equal value the zero (0) will be formatted. The empty
Click to expand...
cell will not be formatted.
 
Back
Top