View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default 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