How can I filter out all the RED color in the excel spread sheet ?

[questionexcelz]

hi all ,

I like to filter all the red boxes in excel. is there anyone who knows how to do it ?

I know how to filter if its a column but what if its the whole excel spread sheet , how can i do it?

thanks !

 

[questionexcelz]

an example

 

[questionexcelz]

what i meant is what i needed is only the red boxes left , with all the other colors gone .

is there any way to do it ?