Automatic select all the rows by font color

[BusinessAanalyst_Alpha]

Hello Guys! Is there any way to auto-select all of the data according to their font color? Example: In the red text color in the table, I want to auto-select (Flores, Gravador, Labrador, Paulo) without clicking them 1 by 1. Thank you and God Bless.

Flores

Gravador

Lallen

Pondosan

Mundia

Cambari

Labrador

Rebutoc

Cabuquit

Paulo

 

[kevin9999]

You can "Filter by color" using Autofilter, if that's what you're looking for. I should point out that when copying your sample data, a total of 3 different shades of red are present - is that intentional, because it'll make a difference if it is.

Book1
	A
1	HDR
2	Flores
3	Gravador
8	Labrador
11	Paulo
12
Sheet1