Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Feb 2009
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I get the RGB (color) of a condtional formatted cell?
    (I want to fill MyShape with the same color of a cell thats been colored by condtional formatting).

    For example:
    MyShape.Fill.ForeColor.RGB = Sheets(1).Cells(r, 7).Interior.Color
    works for retrieving interior cell colors but not for retrieving "condtional formatting" cell colors.

    Guessing its:
    MyShape.Fill.ForeColor.RGB = Sheets(1).Cells(r, 7).???

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    This is quite complicated. See Conditional Formatting Colors on Chip Pearson's website.


Posting Permissions

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