• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 497
  • Last Modified:

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
0
gisvpn
Asked:
gisvpn
2 Solutions
 
regmigrantCommented:
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
 
Rgonzo1971Commented:
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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now