filter rows with shaded cells

D

dinocm

I have a large spreadsheet with color coding in cells (fill color); I would
like to filter the rows to see only those rows with fill color in the cells.

I have tried sorting, filtering but that is not cutting the mustard.

I am using MS Excel 2003.

Txs!
 
N

Nick Hodge

Without code in 2003 you cannot 'filter by colour'.

If the cells are colour-coded, is there something that defines their colour
that you could set up by formula in a 'helper column'?

E.G if the colour is set because the date is at 30 days, 60 days, 90 days,
etc, you could use an IF statement to set the 'helper column' to 1, 2 or 3
and then filter on that. (A bit like a separate index

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
Top