Conditional Filtering

C

carl

I have an area of my spreadsheet that has the conditional filtering activated
- if the ctriteria is met, colr the cell orange.

I would like to copy this area to another worksheet and only have the colors
copied.

Is it possible ?

Thank you in advance.
 
C

carl

hi. thanks. i tried this and excel tells me that cannot use conditional
formating when referncing other workbooks and worksheets. am i setting the
conditional formating incorrectly ?
 
Top