SORTING WITHOUT CHANGE IN FORMAT
 

I have a multiple colored lines' data. Any idea how to sort without
disturbing formats.

THANX

SORTING WITHOUT CHANGE IN FORMAT
 

How are the coloured lines coloured? If by Condiutional Formatting what is
the formula you are using?

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"FARAZ QURESHI" wrote in message
...
I have a multiple colored lines' data. Any idea how to sort without
disturbing formats.

THANX

SORTING WITHOUT CHANGE IN FORMAT
 

Use Conditional Formatting to color-band the rows.

Select a bunch of rows or range of cells and FormatCFFormula is:

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Pick a nice color and OK

The banding will hold through filtering and sorting.


Gord Dibben MS Excel MVP

On Wed, 6 Feb 2008 02:40:06 -0800, FARAZ QURESHI
wrote:

I have a multiple colored lines' data. Any idea how to sort without
disturbing formats.

THANX