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 ...
I have a spreadsheet, cells A1 to D100 are active. If D1 contains a figure I want the whole A1:D1 to change to green. I can do this, no trouble, conditional formating ...