Thread: Extracting conditional format conditions for cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francois via OfficeKB.com Francois via OfficeKB.com is offline
external usenet poster
  
Posts: 109
Default Extracting conditional format conditions for cell
Barb Reinhardt wrote:
I have a range r (which is only one cell) and I'd like to programmatically
determine if there is a conditional format condition with a formula.

To add a conditional format, I do this:

R.FormatConditions.Add Type:=xlExpression, Formula1:="=MOD(ROW(),2=1"

What I want to know is if there is a formula?

Thanks


Something like:-
Range("A1:A1000").Select
Cells.SpecialCells(xlCellTypeAllFormatConditions). Select

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1

Reply With QuoteReply With Quote