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. |
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. |
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. |
All times are GMT +1. The time now is 01:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com