Conditional Formatting Question

[sar130]

I have columns of numbers in which some cells are blank. I would like
to have one fill color for cells in which the number is greater than
or equal to a certain value and another fill color for cells in which
the number is less than that value. At the same time, I would like
the blank cells to remain unformatted. I can use conditional
formatting to achieve the first two objectives, but I can't seem to
figure out how to specify that the blank cells within the column
should remain unformatted. For example, cells with a value greater
than or equal to 50 are light green and cells with a value less than
50 are light red. However, the conditionally formatted blank cells
are also light red no matter what I try. How do I specify a third
condition in which a blank cell remains unformatted? Thanks.

 

[Bob Phillips]

Use a formula of

=AND(A1<>"",A1<50)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Max]

Try this:

Select the column to be formatted, e.g. col A

Click Format > Conditional Formatting

Under Condition 1, put the settings as:
Formula is | =ISBLANK(A1)
[Leave format it as "No Format Set"]

Set-up your other 2 conditions under Conditions 2 and 3

 

[sar130]

Max,

Thanks alot. That nailed it.

 

[Max]

You're welcome !
Pleased to help.