•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I split color-coded cells??
Our take
Splitting color-coded cells in Excel can be a bit challenging, especially when managing room bookings for different classes. It sounds like you're trying to create a more organized view by mimicking the layout of specific rows. While copying and pasting can lead to unexpected results, there are effective methods to split cells. Let’s explore how you can achieve the desired format, ensuring each class's time slot is clearly represented without losing your color coding.
We use an Excel spreadsheet for our room bookings and color code based on which class is using the room. Sometimes when one class uses a room in the morning and another in the afternoon, we need to split the cell. I did not create this document, but I'm trying to make a few cells look like rows 32 and 33 (see screenshot in comments). When I copy and paste into another cell, it takes up two spots. I've watched countless YouTube videos, followed tutorials, and I can't seem to solve this issue. I feel like I'm going crazy!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Anyway to display who made an edit in a cell adjacent to the edit and also make certain cells automatically change color?Hello! I am looking to revamp some documents that my department at work uses (most are on OneDrive since they are getting rid of the majority of our physical storage drives by Q4 of this year.) For several of our spreadsheets, there is a checkbox to see if a task was completed. Is there anyway for an adjacent cell to display which user checked off the task? I know how to make the adjacent cell say true or false, but I was hoping there was a way for it to print the user ID, as people are often forgetting to initial which tasks they have done (A few have complained that there are several people in the department doing nothing all day and I want to prove them wrong). A similar question. I have one specific spreadsheet that uses multiple colors to display what needs done with the data. The cells in columns C through G are the ones that get colored. Again, we use check boxes to show which steps of the process have been competed. Is there anyway to have the cells in individual rows change color depending on which boxes have been checked? Right now we change colors manually. No color means that nothing needs done and none of the boxes are checked Orange means it needs completed now and none of the boxes are checked Blue means it should only be completed by request and none of the boxes are checked Magenta means that steps 1 and 2 are complete, but step 3 still needs completed. The first 2 boxes are checked Green means it is competed. All 3 boxes are checked. I cannot provide my current spreadsheet because I would 100% lose my job if I did. Removing sensitive date would more or less remove everything form the spreadsheet. (names, addresses, what product they are using, etc.) submitted by /u/Cioger [link] [comments]
- Coloured in Cells that link to a google formhttps://preview.redd.it/kwrf9jeec8tg1.png?width=2019&format=png&auto=webp&s=46f64246d5839089bc81e7430f33ee302d323fa0 https://preview.redd.it/6trttn8kc8tg1.png?width=2370&format=png&auto=webp&s=af990b479610a52b0cd385d55f9eeae23c283121 I want to put the table (which is attatched to a google form with checkbox options (as you can see in the WHAT TIME ARE YOU AVAILABLE ON...)), to be able to be formated in the way that the image with the pink boxes is formatted, as a visual representation for myself. But this is obvioiusly tedious to do, creates room for human error and more. Is there a way to automate this? (ignore my typos lmao), submitted by /u/BBearree [link] [comments]
- Invert Multiple Colors in Alternate RowsThis chart needs to have every other row colors inverted. Easy solution? Photos attached. The colors are currently marked with fill color. Open to other ways of defining the color. Hard solution: manually selecting cells to replace, delete and shift left. But there are 500 rows. Edit: The bot thinks this is not related to excel, so throwing in some excel words. Sheet, formula, vba. lol https://preview.redd.it/uk4zc295unpg1.png?width=1959&format=png&auto=webp&s=d0f4b063d2cee9db9b1f274b8ff3dd71f40a8717 https://preview.redd.it/isp7qby5unpg1.png?width=857&format=png&auto=webp&s=3a6c6b723d0271871996fd3825189edc1eebff66 submitted by /u/uaebel_ibag [link] [comments]