Linked cells with patterns

[Alan Dresch]

Hi

Is it possible to 'carry' pattern information,
specifically colours from one linked cell to another?

Alan Dresch

 

[Frank Kabel]

Hi Alan
Excel formulas only link values not format information, etc. So without
using VBA (e.g. processing the worksheet_change event) no chance to
achieve this

Frank

 

[Dave Peterson]

Not by a formula. Formulas only return values.

But maybe you could mimic the formatting via Format|conditional formatting???