+ Reply to Thread
Results 1 to 2 of 2

Check Conditional Formating - Interior Gradient Color Values

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Check Conditional Formating - Interior Gradient Color Values

    Hi all,


    I'm hoping someone can show me how to check for cells background color if conditional format is
    being used with Interior gradient Color Stops. Below is an example of how the color is applied:
    Please Login or Register  to view this content.
    For now, I'd just like the color values for 0 and 1 returned in a msgbox.
    So for the above, the two values being returned would be 39423 and 39270.



    Any help would be appreciated.

    Thanks,

    BDB

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Check Conditional Formating - Interior Gradient Color Values

    HI BDB,

    As per my knowledge, the color picking process from a conditional formatting is completely different from normal color formatted cell, see below discussion happened on ExcelForum :-

    http://www.excelforum.com/excel-prog...using-vba.html
    http://www.excelforum.com/excel-prog...mat-color.html


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

+ 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