Nothing built in, however there is a way of using cell colors
for a possible solution see:

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

Regards,

Peo Sjoblom

"Diane" wrote:

Can the IF function be used to extract cells which contain certain formats.
I have 'colour-coded' values and want to extract them by their colour.
--
Many thanks
D