Automatically assign a cell color to each cell based on value. If there are ten unique values in a range, assign ten colors.

I had previously done this using VBA in an old video: “Assign A Unique Color Value”: Podcast #1718 from May 28, 2013.

In this video, I show how it is easier to use DOSE for Excel to color-code each name or value in a range.

Save 25% on DOSE for Excel using Coupon Code MrExcel25 at https://mrx.cl/getdose