Reverse Conditional Formating
 

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.

surely...just use the formulas or conditions for your formating in a helper
column to extract/analyse your data....
--
paul
remove nospam for email addy!



"Lee" wrote:

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.

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.