autom update cells from Workbook1 to Workbook2
 

Hi,

I have a workbook with 3 sheets
Sheet one of that workbook has some cells with background color red

I have a second workbook with 5 sheets
sheet one of that workbook has some data in some of the cells

Can I in some way automatically update WB2, Sheet 1
with the colors of WB1, Sheet 1 ?

If in WB1, Sheet 1, some additional cells are colored red,
can that be updated to WB2, Sheet 1 also ?

thanks for your assistance !!