Disregard conditional formatting if cell is blank

  • Thread starter Thread starter veronica
  • Start date Start date
V

veronica

I am a novice. I want my cell to highlight if the value is zero. But if it
is blank, or greater than zero, I do not want it to highlight.

I imagine there is an easy way to do this but I haven't figured it out.

Can anyone help?

Thank you so much.
 
Format>CF>Formula is: =AND($A1=0,NOT(ISBLANK($A1)))

How about if the value is less than 0?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format if difference in cell values greater than 0.50% 1
Conditional Formatting and VBA 4
Conditional formatting based on numerical values of adjacent cells 2
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Highlight cells greater than zero 6
Conditional Formatting 1
Excel Excel Conditional Formatting help needed. 1
Conditional Formatting... 2

Back
Top