Conditional Format
Reposted and condensed from post in Worksheet functions.....
A1:A6 can equal dog,cat,fish,bird,horse,snake. I want to conditionally format B1:K6 based on the A1:A6 value. I want a different color for the row dependent on the entry in Column A.
DogRow is Red, CatRow is Blue , FishRow is Green, BirdRow is Yellow, etc.
How do I do this?
Thanks!
Michael E
|