Auto fill colour in different sheets in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2832810%22%20slang%3D%22en-US%22%3EAuto%20fill%20colour%20in%20different%20sheets%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2832810%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BIs%20it%20was%20possible%20to%20link%20the%20cells%20of%20different%20sheets%20within%20the%20same%20workbook%20when%20using%20fill%20colors%3F%3C%2FP%3E%3CP%3EFor%20instance%3A%20If%20I%20colored%20a%20cell%20on%20%22sheet%201%22%20the%20color%20yellow%2C%20is%20it%20possible%20to%20link%20that%20to%20a%20cell%20on%20a%20different%20sheet%20to%20also%20turn%20yellow%20at%20the%20same%20time%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2832810%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

 Is it was possible to link the cells of different sheets within the same workbook when using fill colors?

For instance: If I colored a cell on "sheet 1" the color yellow, is it possible to link that to a cell on a different sheet to also turn yellow at the same time?

1 Reply

@Jennifer2265 If you don't have too many cells and colors you want to use, I would use conditional formatting (CF) based on some value (e.g. a number) that you put in the "first" cell. If you then link the "other cell" to the first one and apply the same CF, the other cell will mimic the format of the first one.

 

A simplified example is attached.