Nope. Formulas return values to cells. The do not modify the size or shape of
cells. Conditional formatting can modify the format of a cell but that is a
long way from what you are trying to do...

You could create a macro, but macros and merged cells don't get along...
--
HTH...

Jim Thomlinson


"Mathicas" wrote:

Hey all,

I have a data entry sheet that I wish to use to create a visual stcaking
plan. (It's a visual representation of which tenants are occuping a certain
floor or space in a building.)

So, right now, I'm inputting a square footage on one page and auto merging
cells on the other page based on the size of the space. Is there any formula
that will automatically merge cells based on a number (the square footage) so
that it will be an accurate representation of the space?