Conditional Formatting - Excel for Blank Cells

hello,

I have the attached spreadsheet however I cannot get the blank cells to be white (I.e. no conditional formatting applied to them when they are blank), I had added the conditional format too of be white should the cell be blank, however it does not seem to work.

Could someone please help me with this please?

Regards,

GISVPN
TEMP.xlsx
gisvpnAsked:
Who is Participating?
 
regmigrantConnect With a Mentor Commented:
you have it correct you just need to move the 'is blank' rule above the others and, optionally, tick 'stop processing' - excel treats a blank as 0 in this context so you are getting two conflicting formats and the first one is applying
Copy-of-TEMP.xlsx
0
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

You have to move your rule above the one with zero because XL evaluate empty cells as 0

see example

Regards
TEMPv1.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.