Filter rows based on cell colour

[redspanna]

Hello all

I have a database with over 300 rows of data.
Data is populated through columns A:X

Is there a way to filter the rows so that only the rows highlighted a certain colour are filtered?

thanks in advance

 

[Gerald Higgins]

Hi, this question is asked quite often on this board.

A search using the terms Filter, Rows, Colour gives lots of results and several possible solutions, like this
https://www.mrexcel.com/forum/excel...lter-colour.html?highlight=filter+rows+colour