Conditional Formatting - Excel for Blank Cells

Posted on 2014-03-10
Last Modified: 2014-03-18

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?


Question by:gisvpn
LVL 19

Accepted Solution

regmigrant earned 250 total points
ID: 39918038
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
LVL 49

Assisted Solution

Rgonzo1971 earned 250 total points
ID: 39918048

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

see example


Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article will show you how to use shortcut menus in the Access run-time environment.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now