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.