Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Filtering
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Filtering | Excel Worksheet Functions | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |