Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2011
    Location
    Miami, Florida
    Posts
    10

    Unanswered: Sorting/Extracting by cell color

    Hi Guys !!!


    Is it possible to have excel take data from a colored cell (or cells) and display it somewhere else?

    I've been trying this for some time and I've had no success.

    Thanks
    Manish

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    You can sort/filter by colour in Excel 2007 or later.

    If there is an underlying logic as to how the cells are coloured (eg. conditional formatting) then that logic could be used to extract the required records.

  3. #3
    Join Date
    Mar 2011
    Location
    Amsterdam, NL
    Posts
    6
    Or use VBA in previous versions of Excel (in 2003 or earlier)

    For example, the following code line only copies the value of cell A1 to cell B1 if the color of the value in cell A1 is red.

    Code:
    If Range("A1").Font.Color = vbRed Then Range("B1").Value = Range("A1").Value
    Hope this helps..

Posting Permissions

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