to find the conditiona format of a cell in vba

[R..VENKATARAMAN]

I have conditional format in C2
the condition is
c2 is grater than B2
I can find this out by selecting C2 and see
format(menu)-conditional format
But is it possible to find out the condtion in vba I am thinking on the
lines

dim x
x=range("c2").formatcondtions(1)

it gives error.

any sugestions or is this not possible?

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.CFConditions.html

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

 

[R..VENKATARAMAN]

Bob Phillips-thank you very much. the webpage is very instructive. I shall
carefully go through the webpage. Lots of informtion..
thank you once again