Query to match the formatting across tabs
Our take
Hi, may be a simple fix for this (i’m quite an excel noobie) but can’t seem to work it out.
so, on Tab A I’ve got 16 unique words on the tab. I’ve personally gone through and given each word its own formatting (basically just a different background colour for each)
Now, on tab 2, these same words (exact same) appear multiple times each in random orders across 5 rows and over a hundred columns
What i want to do is just be able to make it so that this tab matches the formatting form tab A
so, for example Tab A has the word “Succesful” which i’ve put in Green. How can i make it so every time Succesful appears in Tab B it is also green, and then repeat this for all 16 words
thanks for any help
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Combine Tab data into one?Hi, I currently have a workbook with 3 tabs. Two of the tabs I'm downloading data and pasting into every day and with the other I'd like it to combine the data from the two tabs into. They mostly share the same column headers but each have a few unique headers. In that scenario I'd like the columns in the third tab and to remain blank if it's coming from a tab without that column. Pasted below is an example. I don't want the tab names listed, just listing as example to show where they're being pulled from. What would be the best way for me to accomplish this? https://preview.redd.it/jgmrvi5wjtqg1.png?width=385&format=png&auto=webp&s=efe9d5cfc99d429a1d49fa8e4aa655fb7a8bd088 Tab 3 Tab1-A Tab1-B Tab1-C Tab2-A Tab2-B Tab2-C Thanks submitted by /u/easerbreadstick [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]