+ Reply to Thread
Results 1 to 3 of 3

to find the conditiona format of a cell in vba

  1. #1
    R..VENKATARAMAN
    Guest

    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. #2
    Bob Phillips
    Guest

    Re: 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" <venkat1926@touchtelindia.net> wrote in message
    news:eiuEZy$fGHA.4940@TK2MSFTNGP05.phx.gbl...
    > 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. #3
    R..VENKATARAMAN
    Guest

    Re: 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" <bob.NGs@somewhere.com> wrote in message
    news:OktR%233$fGHA.5104@TK2MSFTNGP04.phx.gbl...
    > See http://www.xldynamic.com/source/xld.CFConditions.html
    >
    > --
    > HTH
    >
    > Bob Phillips
    >
    > (replace somewhere in email address with googlemail if mailing direct)
    >
    > "R..VENKATARAMAN" <venkat1926@touchtelindia.net> wrote in message
    > news:eiuEZy$fGHA.4940@TK2MSFTNGP05.phx.gbl...
    >> 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1