filter rows with shaded cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
alternate row shading on filtered data 2
Excel 2007 compatibility issue - speed between cells 2
show fill color of a shaded row 3
fill a cell color using date in one cell and "yes/no" in another c 6
Excel VBA 1
Selection Shading gone from 07' ??? 1
If using =MOD(ROW(),2)=0 conditional formatting and want diff fill 1

Back
Top