Highlighting multiple text within a column

**MARK.ALBRECHT** · 10-05-2014, 11:06 AM

I'm looking for a formula or conditional formatting that will allow me to highlight multiple text within a column i.e.

I need to highlight june,july ,berry and toy in green within column C

**Pepe Le Mokko** · 10-05-2014, 11:12 AM

Try following CF on col C

Please Login or Register  to view this content.

**sakmsb** · 10-05-2014, 01:05 PM

Originally Posted by Pepe Le Mokko

Try following CF on col C

Please Login or Register  to view this content.

I tried that but it says arrays cant be used in CF. May be the one below will be a better option.

your inputs?

=OR($C1="june",$C1="july",$C1="toy") and so on...