Accessing which format is used in Conditional Formatting
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Accessing which format is used in Conditional Formatting

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have cells on which I am using a conditional format. These cells turn red if an error occurs. I would like a macro that takes me to the nest error (unfortunately the formulae are not the same in each cell).

    But if I access the color property through
    interior.colorindex then the color I get is the backgound color that appears if no conditional formatting is active (blue) regardless of whether the user is seeing red or blue on that cell.


    Any ideas?
    cheers
    Duncan

    [ This Message was edited by: Duncan on 2002-02-18 03:31 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You would have to look using the condition... I seem to remember J-Walk listed somewhere (Don't remember exactly where) that you could access the "state" of the conditional format, but, I may be wrong...
    Regards,

    Juan Pablo González
    http://www.juanpg.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com