Excel Conditional Formatting and Blank Cells

B

bxb7668

I would like to apply conditional formatting to a cell that has three
possible values: zero, greater than zero, or blank. The first two are
easy. How do I create a condition that traps a blank cell?

Brian
 
B

bxb7668

Thank you. I didn't know that I could put an equal sign in the value
field. I had just tried entering two quotes which ended up looking
for the string double quote.
Brian
 
B

Bob I

You're welcome, enjoy the day.
Thank you. I didn't know that I could put an equal sign in the value
field. I had just tried entering two quotes which ended up looking
for the string double quote.
Brian
Click to expand...
 

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

Excel does not accept text format! 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Matching literal text "???" in Word 2010 field code IF statement 2
Referencing the values of multiple cells in conditinal formatting. 0
Conditional Formatting and VBA 4
Conditional formatting based on formula cell 4
Conditional Formatting 1
Conditional Formatting - Selective Cell Highlighting 5

Top