•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Coloured in Cells that link to a google form
Our take
Managing availability can be cumbersome, especially when manually formatting tables linked to Google Forms. The visual representation in the provided image highlights a more intuitive approach, using colored cells to indicate time slots. Automating this process not only reduces the potential for human error but also streamlines your workflow. By leveraging AI-native spreadsheet technology, you can transform tedious tasks into efficient solutions that enhance clarity and accessibility. Explore how automation can empower your data management, making your scheduling as seamless as it should be.
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),
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Changing/Automated icons when a checkmark box is ticked?I saw a template made by GoogleSheetsPro on Etsy that had a couple of automated tables and charts, but what stood out for me most was the flower growth one. Every checkbox ticked on a to-do/task table had a flower pot icon change into making the flower slowly grow as more boxes were ticked. How is this done? The charts and tables aren't of any priority, I'm more interested in how they made it fun with icons like a little game. I know it's Google Sheets, but I believe this might be possible with excel. I'd like to implement something similar to my personal sheets! Any help is appreciated. submitted by /u/NovaMorphex [link] [comments]
- Set conditional formatting formula to change cell colors after conditions are met in a separate tabI'm doing r/Fantasy's reading Bingo challenge this year, and thought I'd set up a spreadsheet to help me track my progress. The conditional formatting formulas have been causing me some trouble, though: In Tab 1, I have the Bingo squares arranged in the usual 5x5 grid, and in Tab 2, I have all the squares & their reading rules, hard modes, and completion statuses laid out. I'd love to set it up so that if, in Tab 2, I mark "x square" as completed in "EASY" mode, then the equivalent "x square" cell in the 5x5 grid will automatically change color in Tab 1. Ideally the 5x5 grid won't need any manual color formatting, and I'll only need to edit Tab 2. But I haven't been able to figure out how to make this work across the two separate tabs. In case I'm not describing it well, I'm including an editable Google Sheets version of the spreadsheet for reference: https://docs.google.com/spreadsheets/d/1S6EtJFLLSoysxIp-HHZT_tjVznucJuDbhqpDhbdPZX0/edit?usp=sharing Thanks so much in advance! submitted by /u/defenestratedduck [link] [comments]
- How do I split color-coded cells??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! submitted by /u/bumsleuth [link] [comments]
- How to make conditional formatting exclude blank cellsMaking a working hours chart but I'm not very well versed in many Excel functions so I've been consulting google results for most, but I don't understand why conditional formatting is marking blank cells green for value >0. The detailed issue is as follows: I have columns for for date (C), start time (D), end time (E), and the following (using row 5 for example): Total time F5 =IF(D5;E5-D5;"") Number format: Time Overtime: G5 =IF(OR(F40="";TIME(8;;)="");"";(F40-TIME(8;;))*24) Number format: General I have set up conditional formatting in column G to color everything that is below 0 red, everything above 0 green, but all the blank cells with above formula applied are colored green too. Cells that equal 0 are left without color, as I intended. My hope is that blank cells also remain white until they recieve a value. Is there a way to achieve that? I appreciate all the help! submitted by /u/ace_098 [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#financial modeling with spreadsheets#google sheets#rows.com#Excel compatibility#real-time data collaboration#real-time collaboration#Excel alternatives