Conditional Filtering:Is it possible ?

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

[bj]

use conditional formating on the second sheet, but referencing the first
sheet.

"carl" wrote:

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

[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 ?

"bj" wrote:

> use conditional formating on the second sheet, but referencing the first
> sheet.
>
> "carl" wrote:
>
> > 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.