+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting: Merging Cells?

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Conditional Formatting: Merging Cells?

    I want my spreadsheet to follow this sort of flow:

    1. Enter the name of an HVAC unit in cell A3.
    2. Enter the number of rooms the unit serves in cell B3.
    3. Designate a general classification (e.g. Hospital, Prison, Education) for each room in C3,C4...C*, etc. from a pulldown menu.
    4. Designate a specific classification (e.g. Operating room, autopsy room, dining hall, auditorium) for each room in D3-D*, etc. from a conditional pulldown based on the selection in 3.
    5. Cells in E3,F3,G3,H3 - E*,F*,G*,H* will populate with data based on the selection in 4.
    6. Cell I3 contains a formula that caculates a value based on the numbers in cells E3 - H3. Cell I4 calculates a value for E4 - H4, etc.
    7. Cell J3 sums all of the values in column I that correspond to the unit name designated in A3.
    8. Cell K3 contains a pulldown of values.
    9. Cell L3 calculates a final value based on the numbers in J3 and K3.

    I've attached the spreadsheet, since my description is probably confusing. I've already implemented the pulldowns menus. Basically, I want the sheet to automatically merge the appropriate number of cells in columns A, B, J, K and L based on the response in cell B3.

    For example, if TEST is the name of the HVAC unit, and it serves 2 rooms, I want A3 and A4 to merge into one cell that displays "TEST". I also want B3 and B4 to merge and display "2". I want J3 and J4 to merge and display a number. I want K3 and K4 to merge and retain the pulldown functionality. Finally, I want L3 and L4 to merge. All of this based on the response of "2" in cell B3.

    I feel like this might be beyond the capabilities of excel, but does anyone have any suggestions on how I could do this?
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Conditional Formatting: Merging Cells?

    Excel can certainly do this but this looks like a large project for a free forum?

  3. #3
    Registered User
    Join Date
    05-23-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Conditional Formatting: Merging Cells?

    Quote Originally Posted by Pepe Le Mokko View Post
    Excel can certainly do this but this looks like a large project for a free forum?
    Perhaps, but if Excel can do it, then I should be able to start work on this task somewhere, right?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1