Hi,
I have data in a sheet with something like this:
<tbody>
</tbody>
I would like to colorize with the same background color all rows that have the same value in column B and if there are different values in column B colorize with different colors those rows.
For example in this table,
- all rows in range A:D where value in B is 145 the background is green
- all rows in range A:D where value in B is 234 the background is blue
- all rows in range A:D where value in B is 778 the background is red
May someone help me to do this?
Thanks for any help.
I have data in a sheet with something like this:
A | B | C | D |
File1 | |||
Abs | 145 | YuoJ | 002 |
RFG | 234 | 3op | 009 |
File2 | |||
UYR | 234 | yyt | 3nn |
POC | 778 | www | 334 |
File3 | |||
WEF | 778 | O93 | R67 |
TRE | 778 | 87K | 004 |
<tbody>
</tbody>
I would like to colorize with the same background color all rows that have the same value in column B and if there are different values in column B colorize with different colors those rows.
For example in this table,
- all rows in range A:D where value in B is 145 the background is green
- all rows in range A:D where value in B is 234 the background is blue
- all rows in range A:D where value in B is 778 the background is red
May someone help me to do this?
Thanks for any help.