| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I assume that you have formatted the cell on sheet1 the way you want it (red font strike though etc). Copy this cell and go to the mastersheet and select PASTE SPECIAL. Select FORMAT and then set the cell to look at the other cell on worksheet1 (something like =+worksheet1!a21) Cheers Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=401839 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| copy formulas to different cells in another worksheet | Excel Discussion (Misc queries) | |||
| embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) | |||
| Change the font case of all cells in the worksheet to uppercase? | Excel Worksheet Functions | |||
Hybrid Mode
