Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Conditional Formatting
I have several highlighting rules created for worksheet2.
I would like the same highlighting rules to apply to worksheet1. I have office 2007. I have gone into Conditional Formatting/Manage Rules show formating rules for Sheet 2 all the rules appear I would now like to apply those same rules to Sheet 1. Please help. thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Conditional Formatting
Try selecting the cells in sheet2 then double-click the Formatting
Paintbrush Switch to sheet1 and Paint the desired cells. Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 12:37:08 -0700, ACarella wrote: I have several highlighting rules created for worksheet2. I would like the same highlighting rules to apply to worksheet1. I have office 2007. I have gone into Conditional Formatting/Manage Rules show formating rules for Sheet 2 all the rules appear I would now like to apply those same rules to Sheet 1. Please help. thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Conditional Formatting
That worked.
Thank you. "Gord Dibben" wrote: Try selecting the cells in sheet2 then double-click the Formatting Paintbrush Switch to sheet1 and Paint the desired cells. Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 12:37:08 -0700, ACarella wrote: I have several highlighting rules created for worksheet2. I would like the same highlighting rules to apply to worksheet1. I have office 2007. I have gone into Conditional Formatting/Manage Rules show formating rules for Sheet 2 all the rules appear I would now like to apply those same rules to Sheet 1. Please help. thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel- Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting in Excel | Excel Worksheet Functions | |||
conditional formatting in excel | New Users to Excel | |||
conditional formatting in excel | Excel Worksheet Functions | |||
Conditional Formatting in Excel | Excel Worksheet Functions |