The cells have been manually coloured.



To give a bit of background, I had a second column with information that had to match up, so I wanted to select all rows that contained that piece of information and then color the row to affect the COLUMN A that I am referring to. It's like selecting batches of apples that contain one red apple that has been placed there as an indicator.

COLUMN A has 5 rows of data that all link to one object.
COLUMN B has a 4 categories and language, ie. Russian or English

I need to select all the objects that have "Russian" in COLUMN B, so I need to select 5 rows in COLUMN A for each 1 row in COLUMN B that contains the word "Russian".