Linking Cell Formatting

[elb_iv]

I am trying to link the formatting of a cell on one tab to the cell on another tab. (ie, if the cell on tab a changes green I need the cell on tab b to also change green). Can this be done?

[martindwilson]

you will need code(vba) to do that functions do not copy formats. unless the change is the result of a function itself i.e if your cell x1 says =a1 then the cell on the other sheet could be changed by =x1=a1 even then you'd need a named range for cell for conditional format to work across sheets

[elb_iv]

no the change is not do to a formula, it is changed manually. I do have a basic understanding of VBA, do you have a code that would work for this?

[martindwilson]

well

Please Login or Register  to view this content.

in sheet 2's worksheet module will do that but every time you activate the sheet the macro fires and the undo stack is cleared so you'll have no undo option.