Help with dynamic ranges

[JoAnn]

Can anyone recommend a good book/site/resource for creating and
troubleshooting dynamic ranges & using OFFSET()?

I need to get more general understanding of how they work with examples.
Mine seem to expand the range but don't carry over the formatting.

Thanks,

 

[Max]

Mine seem to expand the range but don't carry over the formatting.

Formulas* cannot carry over formats.
They can only return values in the cells they are placed in.
*any kind, inclusive OFFSET, dynamic ranges etc

 

[JoAnn]

Ok, thanks.
--
JoAnn

Formulas* cannot carry over formats.
They can only return values in the cells they are placed in.
*any kind, inclusive OFFSET, dynamic ranges etc