Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Across Spreadsheets
I want to set the exact same conditional formatting rules across multiple
worksheets in the same workbook using Styles - Conditional Formatting - New Rules. I want to use the same cell range on each of the worksheets. How do I enter the worksheet names in the "applies to" value? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Across Spreadsheets
I'm not sure you can using conditional formating rules...
Perhaps a better solution would be to use VBA??? "Mangerson" wrote: I want to set the exact same conditional formatting rules across multiple worksheets in the same workbook using Styles - Conditional Formatting - New Rules. I want to use the same cell range on each of the worksheets. How do I enter the worksheet names in the "applies to" value? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Across Spreadsheets
That's what I was afraid of, and I am not familiar with VBA. It may just be
faster for me to set the rules separately on each sheet. Thanks "Dan" wrote: I'm not sure you can using conditional formating rules... Perhaps a better solution would be to use VBA??? "Mangerson" wrote: I want to set the exact same conditional formatting rules across multiple worksheets in the same workbook using Styles - Conditional Formatting - New Rules. I want to use the same cell range on each of the worksheets. How do I enter the worksheet names in the "applies to" value? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Across Spreadsheets
Copy the cells with the conditional formatting (as a single block if you
can) then paste special Formats onto the other sheets. "Mangerson" wrote in message ... I want to set the exact same conditional formatting rules across multiple worksheets in the same workbook using Styles - Conditional Formatting - New Rules. I want to use the same cell range on each of the worksheets. How do I enter the worksheet names in the "applies to" value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Cells between Spreadsheets | Excel Discussion (Misc queries) | |||
Conditional Formatting with multiple spreadsheets | Excel Discussion (Misc queries) | |||
Formatting Excel Spreadsheets | Excel Discussion (Misc queries) | |||
Conditional Merging of 2 Spreadsheets | Excel Worksheet Functions | |||
Conditional Formatting with two Spreadsheets | Excel Worksheet Functions |