How to select coloured cells only from a block of cells containing coloured
and non-coloured cells? It may be assumed that the coloured cells are of a
single colour.

Hi Scott,

Have a look at this link.
http://xldynamic.com/source/xld.Colo...r.html#sorting

HTH
Martin


"Scott" wrote in message
...
How to select coloured cells only from a block of cells containing
coloured
and non-coloured cells? It may be assumed that the coloured cells are of a
single colour.

Scott

Which version of Excel?

In 2003 you can specify the Format color to look for under
EditFindOptionsFormatFormat.

You could try this alternate method which doesn't use VBA or any add-ins.

Select the color from the Patterns dialog and Find All.

In the found dialog box the first cell will be highlighted. Hold SHIFT key and
scroll down to bottom of dialog box and select last cell.


Gord Dibben MS Excel MVP

On Fri, 27 Jul 2007 04:10:02 -0700, Scott
wrote:

How to select coloured cells only from a block of cells containing coloured
and non-coloured cells? It may be assumed that the coloured cells are of a
single colour.