An Excel column contains a text value representing the category of that row.
Is there a way to format all cells having a distinct value a unique color without manually creating a conditional format for each value?
Example: If I had the categories bedroom, bedroom, bathroom, kitchen, living room
, I would want all cells containing bedroom
to be a particular color, bathroom
a different color, etc.