Hi Waynef

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Waynef" wrote in message ...
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.