Is there any way to accomplish this? Preferrably without VB code(although it
would seem unlikely to me any other way).

Basically what I have is a worksheet which imitates an Equipment Rack Facial
drawing(say "Rack Profile"). It dynamically populates the data from the
"Devices" worksheet and displays the corresponding equipment rackup RU &
name. It also populates the Power requirements, and is selectable by Row, in
11 Rack increments.

The device names currently populate, but I have to repeat the device name
anytime a device is 1 RU. I was hoping to use Conditional Formatting for
device color & outlining...but I thought that if I could get the cells to
merge/unmerge dynamically, I could use a more simple formula for this...as
well as for aesthetics.

Any advice...has anybody else tried this before?