Solved

Conditional Formatting - Excel for Blank Cells

Posted on 2014-03-10
2
458 Views
Last Modified: 2014-03-18
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
0
Comment
Question by:gisvpn
2 Comments
 
LVL 19

Accepted Solution

by:
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
Copy-of-TEMP.xlsx
0
 
LVL 50

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 250 total points
ID: 39918048
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

856 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