Conditional Formatting

[Me]

Hi to all

A1:A6 can equal dog,cat,fish,bird,horse,snake. I want to conditionally format B1:K6 based on the A1:A6 value. How do I do this?
Thanks!

 

[Domenic]

Hi,

I'm not sure what you're looking for, but if you want to format the row
from Column B to Column K if the value in Column A of the same row
contains any of those words, then try:

Formula Is:
=or($a1="dog",$a1="cat",$a1="fish",$a1="bird",$a1="horse",$a1="snake")

Hope this helps!

 

[ME]

Sorry I wasnt more specific. I want a different color for the row dependent on the entry in Column A.
Dog.Red, Cat>Blue , Fish>Green, Bird>Yellow, etc.

Sorry for the confusion
Michael E