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

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
  • 176