Forum Discussion
EXCEL 2016
Hello I need help figuring out how i can automatically assign different colors to values of cells depending on close the input values are to a randomly set target value
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.