Filtering based on existing background colour

Hi everyone,

I've inherited a job for a local organisation. I have received a spreadsheet that has been created in parts by several other sources. This means it has a load of different styles. I've got most of them sorted but one chap filtered everything by putting a background colour on the row so it was visual inspection.

The problem is that my new sheet has thousands and thousands of rows.

I need to be able to filter (see exclusively) certain records in one continuous column (like the filter function) (the records are in that column already but unsorted/filtered) but the only thing that is unique and common to the records that I want is that they all have the same background colour. All the other records have no background colour in the row. There are thousands of rows in the sheet so going through it manually would be a nightmare. What would also help hugely is if there was some way to then filter further based on the coloured records that have a date within 7 days of another coloured record. So, from the filtered records with a colour, can I filter further and get it to show me those records that occur within 7 days of another record from the filtered list (there's a date column).

Many thanks for your help for a newbie.