Sort List by cell fill colour

[basils57]

Hi Guys

I have various lists consisting of 3 columns; some rows are coloured (only 1 colour); and others have a plain background.
I'm trying to separate this data into 2 separate lists - one showing the filled data and the other showing the data with a plain background.

What is the easiest way of doing this please?

 

[mart37]

With a filter --> filter by color --> colour
Cut and paste to a new locaton

 

[basils57]

Thanks mart37 - should have realised that!