Values are sapphire, ruby, emerald or diamond.
If a2 & b2 match show same value in cell c2. If true d2 is conditionally formatted dependent on the value, if not true c2 is blank and no color fill in d2
if sapphire & sapphire d2 is blue, if ruby & ruby red, if emerald & emerald green, if diamond & diamond gray.
Bookmarks