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?

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?

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?

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?