I have a storage facility where I am trying to use Excel
to track all the units. I understand conditional formatting well enough
to change the text and cell colors for the unit size and current status –
for example, the status cells for empty units are colored yellow —
in my data sheet (which is
Note that Unit 26 (in Row 27), and several others, have status = Empty, and therefore are colored yellow.
I have another sheet that is formatted
to look like the floor plan of the building.
It has merged cells (because the storage units are not all the same size)
which contain the unit numbers
(corresponding to the Unit # in Column
I want to color the units in the floor plan based on the status information. For example, since unit 26 is empty, I want it to be colored yellow. How can I do that?