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?