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 would like to set multipe formating in one conditional formating. range.AddConditionalFormat().WhenIsTrue(string.Format("=$N${0} > $R${0}", i + 13)).Font.FontColor ...

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