You'd have to include a test to make sure the cell does not contain the
formula blank.

Instead of the condition being 0 it should be:
=AND(cell_ref0;cell_ref<"")


--
Biff
Microsoft Excel MVP


"Walley" wrote in message
...
Hi
I use IF(ISNA(LOOKUP(1100;C6:C25));"";(LOOKUP(1E+100;C6: C25)-C6)*1200)
function and I apply Conditional formating with Icon set to fill the cell
with green color if the value 0, red if < 0 and yellow if 0, it work,
but
when the cell is empty it fill with green color. If there is any way to
leave
the color of the cell unchanged
if the cell empty.
Thank