I have a multiple colored lines' data. Any idea how to sort without disturbing formats. THANX
F FARAZ QURESHI Feb 6, 2008 #1 I have a multiple colored lines' data. Any idea how to sort without disturbing formats. THANX
S Sandy Mann Feb 6, 2008 #2 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 [email protected] Replace @mailinator.com with @tiscali.co.uk
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 [email protected] Replace @mailinator.com with @tiscali.co.uk
G Gord Dibben Feb 6, 2008 #3 Use Conditional Formatting to color-band the rows. Select a bunch of rows or range of cells and Format>CF>Formula 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
Use Conditional Formatting to color-band the rows. Select a bunch of rows or range of cells and Format>CF>Formula 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
