Sorting/Extracting by cell color

seoservice · #1 (**permalink**) 02-23-11, 08:07

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

Colin Legg · #2 (**permalink**) 02-23-11, 10:27

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.

Nielsje · #3 (**permalink**) 03-03-11, 13:28

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..

Internet Services

Web Development

Digital Marketing

Consumer Tech