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 ...