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