An Excel column contains a text value representing the category of that row.
Is there a way to format all the 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.