Filtering Data?

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

Guest

Hi all

Is it possible to filter data by the colour of cells? I have a large
worksheet and in Column A, some of the cells are shaded in red. I want to
filter the worksheet so I can only see those records that are not shaded in
red.

Don't know what function would be best for this?

Thank you for any help.

Regards.

Louise
 
Thanks very much, Frank. I didn't realise it would be so complicated!!

Louise
 
You must log in or register to reply here.

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

Comparison of columns using Conditional Formatting 3
Formula that compares Cells and formats if not equal 2
need help on either doing a loop and counting specific values orusing subtotal function 2
Excel data filtering 2
sort 2
Need a shaded row in Excel that doesn't move as data changes 1
Formatting of cells in a locked worksheet. EG shading 1
VBA to Filter on variable column 5

Back
Top