@khb250
It depends on how many colors you want.
If you want to assign just three or four different colors, you can color the cells themselves, with one conditional formatting rule of type formula for each color.
But if you want many colors, that becomes tedious. It'd be easier to use a separate range with the differences, and use a single conditional formatting rule of type color scale.
In the attached workbook, I have illustrated both approaches.
