VBA Conditional formatting
 

I can change the conditional formats of cells with the
FormatConditions Object. But is it possible to get the conditional
formats from a cell in Excel to show them in VBA?


--
Steven E.
------------------------------------------------------------------------
Steven E.'s Profile: http://www.excelforum.com/member.php...o&userid=15123
View this thread: http://www.excelforum.com/showthread...hreadid=268130

VBA Conditional formatting
 

? activeCell.FormatConditions(1).Formula1
5000
? activeCell.FormatConditions(1).Formula1
5000
? activeCell.FormatConditions(1).Operator
1

But See Chip Pearson's page on Conditional Formatting Colors

The code there will show you how to interpret the formulas.

http://www.cpearson.com/excel/CFColors.htm

--
Regards,
Tom Ogilvy

"Steven E." wrote in message
...

I can change the conditional formats of cells with the
FormatConditions Object. But is it possible to get the conditional
formats from a cell in Excel to show them in VBA?


--
Steven E.
------------------------------------------------------------------------
Steven E.'s Profile:
http://www.excelforum.com/member.php...o&userid=15123
View this thread: http://www.excelforum.com/showthread...hreadid=268130