Conditional formatting on multiple rows with different names

Harsh Sutaria - Sep 11, 2017 at 03:12 PM
Hello,

I have 4 names in column A

SEGMENT - ADULT ORG
SEGMENT - CORE
SEGMENT - LIGHT
SEGMENT - PROACTIVE HEALTH

I want to use a conditional formatting where each time it finds one of them it colors the entire row, each row should be different colored for eg SEGMENT - ADULT ORG - Red,
SEGMENT - CORE - Blue etc.

Please help

See more