Cell colour based on 10 different values

[ryan7]

I have 1000s rows of info.
Columns AB has 10 possible values.
I would like the colour of each cell to be based within.
AAA
AA
A
BBB
BB
B
CCC
CC
C
D

 

[Beneindias]

You'll need to create 10 conditions on formating, each value should have a condition

 

[ryan7]

You'll need to create 10 conditions on formating, each value should have a condition

When I create the first two,
AAA and AA, it formats to the same colour

 

[Beneindias]

When I create the first two,
AAA and AA, it formats to the same colour

You need to check that option "Stop if true".
At least, it fixed the problem in my file.