This doesn't accomplish the goal to match the color though. I would have to do a separate formula for each category (i.e. dog, cat, rat, snake, moose, hundreds more). Plus I would have to do a separate conditional format for each subcategory (the breed) under each species. Perhaps there is just not an easy way to accomplish this?