Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copy formatted (red font) cells from one worksheet to another
How do the result displayed and updated in a cell on 'worksheet 1' mirror or
copy the red font color (and strike through) of a cell on a seperate worksheet automatically? - 'worksheet 2'? on worksheet 1 it is currently black, but when I cross it off (red font and strike through) - I want it to update this action / result to a master list so that I dont have to update both worksheets. thanks. |
#2
|
|||
|
|||
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 |