Conditional format if cell = blank

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

what is the right formula to use for conditional formating for if the each
is blank (no data)? Thanks
 
=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
 
Back
Top