Solved

Conditional Formatting - Excel for Blank Cells

Posted on 2014-03-10
2
451 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 49

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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 …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

832 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