I have a sheet that has some cells with conditional formatting. I then have a summary sheet to be used for printing that will duplicate certain cells from the first sheet. I need those cells to match the conditional formatting from the cells in the first sheet. Can this be done in Excel 2010?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Match Conditional Formatting
- Thread starter joek003
- Start date
Robert Mika
MrExcel MVP
- Joined
- Jun 29, 2009
- Messages
- 7,256
Hi joek and welcome to the board.
If you want to have the same CF on corresponded cell in your other workseheet just use Format Painter from the Clipboard Section on Home Ribbon.
Click on the cell you want the CF to be copied and paste on the destination cell.
Hope that helps.
If you want to have the same CF on corresponded cell in your other workseheet just use Format Painter from the Clipboard Section on Home Ribbon.
Click on the cell you want the CF to be copied and paste on the destination cell.
Hope that helps.
Upvote
0
That doesn't work as I only have selected fields in my second tab. I don't want all the extra cells and formulas that drive the conditional formatting in the first tab. I'm just trying to get a few selected cells in the new tab and wanted the formatting to look the same as the detailed tab.
Is that clearer?
Is that clearer?
Upvote
0
Similar threads
- Solved
- Solved
