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.