copy formatted (red font) cells from one worksheet to another

G

Garrett

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.
 
J

Jon Quixley

I assume that you have formatted the cell on sheet1 the way you want i
(red font strike though etc). Copy this cell and go to the mastershee
and select PASTE SPECIAL. Select FORMAT and then set the cell to loo
at the other cell on worksheet1 (something like =+worksheet1!a21)

Cheers
Jo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy cells from one worksheet to another 1
Problem with MS Word paragraph and character styles: format getting messed up 2
copying colored cells 3
one cell in my worksheet appears blank, but answr shows in formula 6
Repetive Formatting/Creating a Toolbar button 11
Duplicating a cell from one worksheet to another worksheet 1
Change font color automatically 7
Cell formatting doesn't display 1

Top