See

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Lee" wrote in message
...
Does anybody know whether you can effectively run a reverse conditional
format. In other words organise use cell formats to analyse data in a
spreadsheet and run scenarios. So if I have three different fill colours
for
a data range can I extract data by cell colour.