Use formula is

=A1=""

will work

OR cell value equal to =""


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Mary Mayo" wrote in message
...
I have a wksht where I want to have all blank cells auto color fill to
indicate data not yet rec'd/entered. Conitional formatting requires a
value
be assigned - have tried to leave value as blank, and apply formatting,
but
it doesn't work - there's got to be an easy answer and I'm just not seeing
it! Help - it's driving me nuts!!!