filtering by colour

  1. B

    Comparing Two Contents Of Two Lists

    Hello - I applied a conditional formula =SUMPRODUCT(--ISNUMBER(SEARCH(Fortune_List,B2)))>0 to my list and I believe it worked. However, my first list has 45000 rows in it so I can filter by color to check and make alterations to the list. ? How can I filter by color, 45,000 rows? Thank you
  2. R

    Filter rows based on a column colour with one click

    Hi there gurus! I am trying to achieve the following, and failing dismally.... We use a large spreadsheet of events. Each type of event has a different colour, so Blue wedding , Green Wine Tasting, Red Conference and so on. The first 4 columns of each event row are background filled with that...
    • Rob-UK
    • Thread
    • colour event filtering by colour one click filter spreadsheet
    • Replies: 6
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top