Gregg Wolin
Member
I'm struggling to conditionally format the color of an icon ( / ) based on the value of the neighboring cell. The screenshot illustrates my goal. The first column only has 2 of the same entries so a single color (/) is fine. Column 2 has 4 total entries, with 2 being unique. Column 3 illustrates what I'm going for with 4 unique entries. As there could be a large number of unique entries, using a color ramp based on the number of unique category entries would be ideal. Is this possible?
![Screen Shot 2020-10-10 at 2.27.10 PM.png Screen Shot 2020-10-10 at 2.27.10 PM.png](https://chandoo.org/forum/data/attachments/71/71648-677d50020bc42d0f9f3e6fbf6827b794.jpg)
![Screen Shot 2020-10-10 at 2.27.10 PM.png Screen Shot 2020-10-10 at 2.27.10 PM.png](https://chandoo.org/forum/data/attachments/71/71648-677d50020bc42d0f9f3e6fbf6827b794.jpg)