Try

=AND(B26<"",B26=0)

This can be copied to cells C26:Z26 using the format painter. If you
want the reference in the condition to change to each cell, be sure to
remove the $'s from the formula. I here you on the Thanksgiving thing.
Luckily, half a day for me.



Cheers,

Steve


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