lookup certain formatting

[Waynef]

How do I write a formula that only returns values with a certain type of
formatting,Let say I only want it to return all the value that is in red.

 

[Ron de Bruin]

Hi Waynef

Start here
http://www.cpearson.com/excel/colors.htm