Conditional format if cell = blank

C

Cam

Hello,

what is the right formula to use for conditional formating for if the each
is blank (no data)? Thanks
 
P

Peo Sjoblom

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
conditional formatting update issue 5
Conditional Formatting 3
Changing row background from external program 0
Referencing the values of multiple cells in conditinal formatting. 0
Conditional Formatting 1
Conditional Formatting Amendment 2
Adding data to MS Access from csv file 0

Top