to find the conditiona format of a cell in vba
 

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?

to find the conditiona format of a cell in vba
 

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

--
HTH

Bob Phillips

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

"R..VENKATARAMAN" wrote in message
...
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?

to find the conditiona format of a cell in vba
 

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


"Bob Phillips" wrote in message
...
See http://www.xldynamic.com/source/xld.CFConditions.html

--
HTH

Bob Phillips

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

"R..VENKATARAMAN" wrote in message
...
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?