facility-management | Facility Management tool that tracks foot traffic | Runtime Evironment library

I suggest you don't use VBA to color the cells, but conditional formatting. That will be a lot easier. Use your code to enter a number into the cell you touch, or remove it. Then use worksheet formulas to calculate the totals and use conditional formatting for the fill colours. That way you don't change the colors with VBA at all.

With each cell change, you want to update the table at the top to show a comma separated list of row numbers that are marked with that category letter. You can do that by using a change event that monitors only the data entry cells and then loops through all rows of data, column by column. If the current cell has the value 1, then append the row 's floor number to the summary table at the top.

Your layout for the summary table is different from the data entry layout, so there will need to be some extra code to identify which cell to write the result to.

Here is a similar layout that I used in my code.

This worksheet change event re-calculates the values in the summary table whenever a value in the input table has been changed. You need to adjust this code to reflect your worksheet target rows and columns, but the comments should help you figure that out.