Linked formatting across worksheets

[Will Emms]

Hi. I have set up a spreadsheet with three worksheets, the first one linking
to the other two, so when I add in information on first sheet, it appears on
the other two sheets in the appropriate columns.
I want to be able to keep track of the status of particular lines of
information by highlighting them on the front sheet in different colours and
would like the highlighting to transfer over to the other two sheets.
Can it be done?
Many thanks

 

[Gary''s Student]

While you can't link formats directly, you can:

1. Copy/PasteSpecial from one sheet to another

or

2. Use Conditional Formatting in both sheets with the same condtions.