Excel 2007 : Sorting/Extracting by cell color

**FTN** · 02-22-2011, 03:31 PM

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.

**mrice** · 02-22-2011, 04:27 PM

This can be done by macro. Can you provide an example?

**FTN** · 02-23-2011, 11:28 AM

A super-simplified version of my sheet is attached. All I need it to do is to take the values highlighted in each color and display them on another sheet.

**mrice** · 02-23-2011, 04:08 PM

Do you need the values to be brought into adjacent cells in the new sheet or just copied in their same relative positions?

If its the latter then the following macro will delete the contents of all cells which do not have a background colour.

Sub DeleteIfNotColoured()
Dim Cell As Range
For Each Cell In Selection
    If Cell.Interior.Color = 16777215 Then
        Cell.ClearContents
    End If
Next Cell
End Sub

You could use this on a copy of your sheet.

**FTN** · 02-24-2011, 11:49 AM

Ideally I need it to take the values in each cell and deposit them onto another sheet in order according to their color, making one row of 'green' and one row of 'blue' values.