CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaconditional-formatting
Lizi1990
Lizi1990

Reputation: 103

Color the entire cell according to a particular text using conditional formatt

When we select a text from a drop-down list can we color the entire cell according to a particular name in that dropdown list. for eg; if we select "bolero" from drop down list. the entire row must turn red.

here is the worksheet. https://docs.google.com/spreadsheets/d/1VsLKHSZsTMeBctnINnsixKISgNkTHDV-dkO4ORsDjgI/edit#gid=1975041699

Thanks in Advance

Upvotes: 1

Views: 69

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

Please use the following formula as a conditional rule

=$C2="BOLERO"

enter image description here

(If you want to use different colours for the rest of the brands/names, just create more filters like =$C2="XUV")

Upvotes: 4

Related Questions