Conditional formatting on multiple rows with different names in Excel -
i have 4 names in column segment - adult org segment - core segment - light segment - proactive health i want use conditional formatting each time finds 1 of them colors entire row, each row should different colored eg segment - adult org - red, segment - core - blue etc. please