The problem is that in Excel's ranking system a blank is deemed to be
bigger than any number, hence the formatting.

One way round this would be to change your second condition. If the
cell that you're formatting is A14 use the "formula is" option and the
formula

=(A141)*ISNUMBER(A14)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528684