| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditiona format based on format of another cell | Excel Worksheet Functions | |||
| Conditiona format | Excel Discussion (Misc queries) | |||
| Vlookup 2 conditiona | Excel Discussion (Misc queries) | |||
| find word in a cell then change cell format | Excel Programming | |||
| how do I search for any cell containing data and apply conditiona. | Excel Discussion (Misc queries) | |||
Hybrid Mode
