•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Set conditional formatting formula to change cell colors after conditions are met in a separate tab
Our take
Managing your reading progress can be an exciting challenge, especially when using a spreadsheet for r/Fantasy's Bingo. To enhance your experience, you can set up conditional formatting that automatically changes cell colors in your 5x5 grid based on completion statuses from a separate tab. By marking squares as completed in Tab 2, you can visually track your achievements in Tab 1 without any manual formatting. This approach simplifies your workflow, allowing you to focus on enjoying your reading journey while effortlessly managing your progress.
I'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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Conditional formatting based on a range of text in 2nd sheetHey! I have a two sheet workbook. First sheet has column A: list of order numbers that should be highlighted based on status and column B: status. the status text comes from a list in the second sheet. all possible statuses are listed from A1:A10 on the second sheet, but there might select colors per status (like from A1:A3 and A10 would all need the same color) Right now I have as a formula: =$B1='Sheet2!A1 and that works, but trying to use a range doesn't work =$B1='Sheet2!$A1:$A$5 I'm certain I'm overlooking a basic issue, but my googling skills are failing me 😞 submitted by /u/jaegerjockey [link] [comments]
- Conditional formatting based on a different cell's valueI'm fumbling my way through conditional formatting on a tracking sheet I'm creating. I have the status and required delivery formatting the way I want, but now I'm running into an issue where I want it to clear the formatting of the required delivery cell once the status cell is set to "complete" like the bottom row. The status cells are drop down menu if that makes a difference. https://preview.redd.it/0va9fhl9tlvg1.png?width=346&format=png&auto=webp&s=a470a51c639e165a0e4bb41b626d60743cf457c1 I've tried playing around with "IF" formulas, but nothing seems to be happy with what I'm trying. Any thoughts? submitted by /u/Senior_Cheesecake155 [link] [comments]
Tagged with
#google sheets#rows.com#natural language processing for spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#Excel alternatives for data analysis#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#big data management in spreadsheets#AI-native spreadsheets#financial modeling with spreadsheets#predictive analytics in spreadsheets#cloud-native spreadsheets