Problem with conditional formatting, format only cells with Blanks

hi there,

i'm having trouble conditional formatting.

my issue is:

i have range 10 cells. in 10 cells, have 2 blank cells (means contain nothing); , 1 cell contains spaces

when used conditional formatting, rule type is: format cells contain

rule description is: format cells with: blanks

and problem is: 3 cells hightlight (not 2, 3). what's going on? 2 cells empty (blank), 1 cell not, contains spaces.

i checked countblank in 10 cells range, , returns 2.

i'm using personal laptop, office professional plus 2010. , checked issue on friend's laptop, office 2016, , same problem.

any suggestion problem?

thanks!

***post moved moderator appropriate forum category.***

yes! sees space blank. consider bug try following work around.

select "use formula determine cells format"

enter following formula a1 first cell in "applies to" range (ie. range conditional formatting). ensure include leading equals sign.

=isblank(a1)

Office / Excel / Microsoft Office Programming / Office 2010

Cororate