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

G

Guest

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
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cannot copy worksheet to another file 2
one cell in my worksheet appears blank, but answr shows in formula 6
Change default font color for a single spreadsheet? 10
Copying template from one worksheet to another 2
A cell copied onto one worksheet from another worksheet does display same formatting. 3
Copy Cells from multiple Worksheets in same workbook. 2

Top