Conditional Format with OR function

[pmdcmatt563]

Please Help.

I want to apply conditional formatting in a cell based on the contents of another cell. I can do it if I just want it based off 1 condition (=b151="sample") but would like to if it met 1 of a couple possibilities.

For example, cell H151 I would like to fill green if cell B151 contained the text "sample" or "example". B151 has a list box with about 10 possibilities but I only want a few of those to turn H151 green.

Thanks

 

[ZAX]

It's Simple,You use an OR function and type all the possibilities you like :

=OR($H$151="Sample",$H$151="Example")

ZAX

 

[pmdcmatt563]

Thanks, that works.

If I want to do that for multiple rows, do I have to manually change the Formula per row? If I copy it to the next row it still keeps the previous row number and bases it on that.

 

[ZAX]

You mean like B151 Is green if h151 is "Sample",b152 is green if h152 is "Sample",,,....etc?
you'll have to remove the "$" sign before the row number from the function as the following :
=OR($H151="Sample",$H151="Example")