If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Conditional Formatting and Blank Cells
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 |
#2
|
|||
|
|||
The following = blank
"" bxb7668 wrote: 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 |
#3
|
|||
|
|||
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 "Bob I" wrote in message ... The following = blank "" bxb7668 wrote: 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 |
#4
|
|||
|
|||
You're welcome, enjoy the day.
bxb7668 wrote: 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 "Bob I" wrote in message ... The following = blank "" bxb7668 wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting on 0 affecting blank cells | Roz | Worksheet Functions | 2 | July 8th, 2004 09:58 PM |
Conditional Formatting Questions | Andy B | Worksheet Functions | 1 | May 12th, 2004 02:48 PM |
Conditional Formatting & Blank Cells | Dominique Feteau | Worksheet Functions | 5 | February 26th, 2004 12:41 AM |