Thread: VBA Conditional formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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



Reply With QuoteReply With Quote