Help Please - Conditional Formatting

B

baz

I am trying to put in a second conditional format.

I am selecting cells A11 thru I11. My first conditional format is:
Formula Is: =IF(and($B11>=4180000000,$B11<=4180099999),$B11)

B11 is my key cell.

I want to add a conditional format because I now have a 0 (zero) in
three instances of column B. I want the same formatting to occur as
happens in condition one.

The final result I want is the pattern I chose to appear if the value
is between 4180000000 and 4180099999 or = 0 (zero)

Thanks for any help.
 
N

Norman Harker

Hi Baz!

Try changing your first condition:

=OR($B11=0,AND($B11>=4180000000,$B11<=4180099999))
 
N

Norman Harker

Hi Baz!

Thanks for thanks and the confirmation it works. The important thing
with the formulas for conditional formats is that they must resolve to
TRUE or FALSE. You can always pre-test them as a cell formula.
 
Top