Add additional statement for use within conditional formatting

[suprsnipes]

Hi,

I need to add an additional statement for use within conditional formatting but I'm not sure how.

Currently it looks like this

=$B51>=$G51*2

I want to also add the following;
If $B50 does not contain the letter "O"

Appreciate the help.
suprsnipes

 

[number kruncher]

Try..

=AND($B51>=$G51*2,$B50<>"O")

 

[JamesW]

Hi,

Try:

=AND($B51>=$G51*2,NOT(ISNUMBER(FIND("O",$B50,1))))

 

[suprsnipes]

Thanks for the suggestions I used the following from JamesW;

Hi,

Try:

=AND($B51>=$G51*2,NOT(ISNUMBER(FIND("O",$B50,1))))