Help Please - Conditional Formatting

[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.

 

[Norman Harker]

Hi Baz!

Try changing your first condition:

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

 

[Guest]

Norman:

Thank you so much. This does the trick

baz

 

[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.