Reverse Conditional Formating

L

Lee

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.
 
P

paul

surely...just use the formulas or conditions for your formating in a helper
column to extract/analyse your data....
 
Top