Conditional Filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
use conditional formating on the second sheet, but referencing the first
sheet.
 
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 ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting 2
copy rows to another worksheet with conditions 2
Excel Highlighting duplicates 0
Excel VBA 1
Returning 1 of 4 values if conditions are met 4
Conditional format cell containing hyperlink 2
Formula to color cells based on result 2
Excel 2007 - copying filtered data to another workbook 1

Back
Top