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?