Use a color gradient to differentiate values. For example, smaller numbers can appear red, and larger numbers green. Icon Sets Add icons (arrows, stars, traffic lights, etc.) to represent different ...

This Excel add-in demonstrates a known issue with using custom functions inside conditional formatting rules. The add-in creates custom functions and applies conditional formatting to cell C1, but ...