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.
1 Answer
Check the following .gif
I take rows with id = 2 as an example, they will be highlighted with red. Used the formula:
=$A1=2Other ids are similar.
