Conditional Format for Non-Blank Cell

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Good Morning All,

I'm using Excel XP.

I have a worksheet that consist of numeric values, including zeros and blank
cells. I'm having a problem setting up a conditional format that will fill
in a background color if the value in the cell is 0 or above. When I enter
cell value in the conditional format to greater than or equal to 0 it gives
a background color to all the cells. What I want is to give a background
color to all numeric values INCLUDING the zeros, but not the blanks.

Thank you in advance for any help,

Michael
 
Hi Mike!

Try:
Formula is:
=AND(ISNUMBER(A1),A1>=0)

Select the range of cells first and replace A1 above by the top left
cell in your range.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top