View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Me Me is offline
external usenet poster
 
Posts: 67
Default 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