Formatting background color issues. HELP!!!

[Syd]

Hey, guys

Here is the problem. I am using the conditional formatting tool to set conditions in two column ranges.

The the first condition reads as follows: "If the value in the cell is greater than 1, make the background color Red". However, since the cells in the range cells below may be empty ("" or 0) these cells are also changed to red.

The second columns condition reads: "If the value in the cell is less than 1, make the background color Red". The cells in the range cells below may be empty ("" or 0) these cells are also changed to red.

Is here a way to prevent the other cells in the range from changing to red pre-maturely, prior to get a value

Any assistance will be appreciated

Thanks,

 

[Frank Kabel]

Hi Syd
for the first column the result sounds strange. If you only select the
first column and set the conditional format for this cell as you
described, blank cells should not get any format.
For the second column enter the following formula for conditional
format (if B1 is the first cell in this range):
=AND(B1<1,B1<>"")

HTH
Frank

 

[Bob Phillips]

Syd,

Try this formula

=AND(A1>1,A1<>"",a1<>0)
and
=AND(A1<1,A1<>"",a1<>0)

to cater for blanks and zero

--

HTH

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

Hey, guys:

Here is the problem. I am using the conditional formatting tool to set

conditions in two column ranges.

The the first condition reads as follows: "If the value in the cell is

greater than 1, make the background color Red". However, since the cells in
the range cells below may be empty ("" or 0) these cells are also changed to
red.

The second columns condition reads: "If the value in the cell is less than

1, make the background color Red". The cells in the range cells below may be
empty ("" or 0) these cells are also changed to red.

Is here a way to prevent the other cells in the range from changing to red

pre-maturely, prior to get a value?