Sean,

If you are just inputting the numbers the =ISBLANK(A1) is fine but
A1 will not format if there is a formula in A1 even if the cell appears
blank as a result of the formula.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540311