0

I work on table like this:

id seller state reason
1 bla1 approved not supported
1 bla2 rejected rejected by seller
2 bla3 rejected rejected by seller
2 bla3 failed error
3 bla1 failed failed to get
3 bla2 pending failed to get
4 bla4 rejected not supported

I want to highlight the rows based on the id column - rows with id = 1 will be highlighted with one color, rows with id = 2 will be highlighted with second color, etc.
I didn't find an option to this with conditional formatting.
Will appreciate any help.

aamath
  • 5
  • 2
  • How many different IDs? if too many, that could be a lot of eye-boggling colours and lots of rules to manage (and note that conditional formats are always volatile). Have you considered allowing the user to choose just one or two ids through a drop-down list in a cell for example, and colouring only those? – AdamV May 26 '21 at 08:51
  • See also [Change Fill Color for Entire Row  when Value in a Cell Changes](https://superuser.com/q/1509379/150988). – Scott - Слава Україні May 27 '21 at 05:33

1 Answers1

1

Check the following .gif

I take rows with id = 2 as an example, they will be highlighted with red. Used the formula:

=$A1=2

Other ids are similar. enter image description here

Erin
  • 156
  • 3