I'd like to apply a color gradient to a range of cells based on the number of times a text value appears in that range. For example:
Burn
Burn
Sprain
Laceration
Burn
Sprain
'Burn' appears the most, so it would appear red in the standard gradient pattern. Laceration only appears once, so it would be green. Values that appear more or less frequently would appear in varying shades from green through yellow to red.
Right now I have a separate table under my data with a COUNTIF function used to apply the colors, but I'd like to put the formatting into the main table using a conditional formula that does the math and applies the color gradient. I've viewed another thread where individual colors were assigned based on discrete frequencies, but that seems a little awkward when I'd have to add another formula every time an entry appears more frequently than the previous maximum number.
Can Excel do this?
Bookmarks