Highlight Blanks and not "spaces" - conditional formatting

hshannon87

New Member
Joined
Sep 3, 2019
Messages
1
Hey there, i am trying to highlight if a cell is blank, but don't want " " (a space) to be considered a blank cell.
I tried adding a ' before the space, and this doesn't work.

Any ideas?
isblank and not " "
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,783
Office Version
365
Platform
Windows
Welcome to the Board!

You can just check for value of "" for blankl, or use the LEN function to check the length is 0, i.e,.
=LEN(A1)=0
 

Forum statistics

Threads
1,085,724
Messages
5,385,515
Members
401,957
Latest member
Socksnpants

Some videos you may like

This Week's Hot Topics

Top