Conditional format if cell = blank
=A2=""
if you want the formatting to go into effect when the cell is blank
This works as well
=LEN(A2)=0
--
Regards,
Peo Sjoblom
"Cam" wrote in message
...
Hello,
what is the right formula to use for conditional formating for if the each
is blank (no data)? Thanks
|