Conditional formatting flag
in [General]
|
Prev: (Invulformulier WK2010 + nieuwe versie.excel) [0/1] - "Deelnemer_invulformulier_WK2010.nzb" www.vmp-online.com (1/1)
Next: Excel will not open in default file location
From: bds on 9 Mar 2010 13:03 Is there an accessible flag that indicates whether Conditional Formatting of a cell is active? I'd like to show a value in one cell based on whether a Conditional Format condition is active in any of a group of cells.
From: Dave Peterson on 9 Mar 2010 13:33
Accessible to what? I would do my best to use another cell that mimics the rules of the conditional formatting. Then I could check this other cell. But if you really, really want (it ain't for the faint of heart!), take a look at how Chip Pearson does it: http://cpearson.com/excel/CFColors.htm bds wrote: > > Is there an accessible flag that indicates whether Conditional Formatting of > a cell is active? I'd like to show a value in one cell based on whether a > Conditional Format condition is active in any of a group of cells. -- Dave Peterson |