Hi Dorian,

Am Thu, 5 Apr 2012 06:21:38 +0000 schrieb Dorian74:

i have the table below. I added the conditional formatinng below to
these cells. however, the "blank" cells are colored red instead of only
cells with value greater then "0".

a cell has value=0 if the cell is empty. But you have a formula in it.
Try CF with formula:
=AND(ISNUMBER(N4),N40)



Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2