G Guest May 4, 2006 #1 Is it possible to format only cells that specifically read $0.00? Every time I try all the blank cells and cells reading 0 also change.
Is it possible to format only cells that specifically read $0.00? Every time I try all the blank cells and cells reading 0 also change.
P Peo Sjoblom May 4, 2006 #2 You could try something like =AND(A1=0,A1<>"",LEFT(CELL("format",A1),1)="C") however it's not very reliable -- Regards, Peo Sjoblom http://nwexcelsolutions.com
You could try something like =AND(A1=0,A1<>"",LEFT(CELL("format",A1),1)="C") however it's not very reliable -- Regards, Peo Sjoblom http://nwexcelsolutions.com
