Conditional Formatting or a Specific Filter Rule
Dear Experts , I have a data like below:- here the Column-O, txNumber can go from 1,2,3 (txNum=2 and 3 means a Retransmission), I want to filter all the pairs for all Transmissions and their corresponding Retransmissions ( either by coloring them all using a conditional formatting) or using a specific filter Rule. How to identify the Transmission and it's corresponding Retransmission for a Specific HarqId( say for dlHarqProcessIndex ==7, the blue color Row-37 is my 1st transmission(txNumber ==1) for the dlHarqProcessIndex==7 with a tbSize of 852696, and adaptRetxStatus == NOTACTIVATE, and it's corresponding 2nd transmission( Retransmission , txNumber==2) Row-45, tbSize remains same(as it's corresponding 1st transmission) in all retransmissions and adaptRetxStatus changes to "APPLY" for all retrans txNumber==2,3) and similarly for other pairs like for dlHarqProcessIndex==13. Attached is the Worksheet.
Conditional Formatting a specific word
First post here, so hoping someone can help me. I work for a repair facility. I track our repairs in excel. I have an “order” tab that tracks all the important information for the repairs. I also have an “inventory” tab that shows what parts we have in stock in our inventory. Also on this tab I do a daily data dump of all the parts needed for each order. I use this dump to fill in a “parts needed” column on the repair tab to show what specific parts, based on part name, an order needs to be completed. Is there a way for me to condition the “Parts Needed” cells on the repair tab to highlight the part name if the part shows in stock on the inventory tab? I.E - Repair tab: order 0001 for Jane Doe Started work 1/23/45 needs parts: mouse, keyboard, monitor, hard drive Inventory Tab: Daily parts dump: order 0001 - part needed: mouse order 0001 - part needed: keyboard order 0001 - part needed: monitor order 0001 - part needed: hard drive In stock report: Mouse 10 Keyboard 0 Monitor 0 Hard drive 5
Excel Map - One region is recognized but not showing up in color
Hi, As shown below, I am trying to map out the number of farmers in our data in each of Georgia's regions. Samegrelo Zemo Svaneti is recognized and the data label appears but the color does not. If I change the map to show only the regions with data, it does show in color but I need the full country map.
File always corrupt
Anyone have the same problem with me? I use microsoft excel 365 on my mac. At the beginning everything alright, until i use formula and then save the file. When i want to re-open the file, the messagebox showed up "we found something wrong in your content...". It gives 2 option, yes and no. If i click no, the file wont open. If i click yes, the file open, the excel do the recovery, the file open but end up with all the formulas is gone, deleted by excel and just left the value. What should i do? Do the file can still be fixed?
Side load office add-in?
I've created an office.js add-in that I can test with debugging in VS Code. I have deployed it including the manifest to a web site, but now I can't find the option to add it to my Excel anymore, where has that option gone? I'm on Microsoft® Excel® for Microsoft 365 MSO (Version 2602 Build 16.0.19725.20126) 64-bit Thanks GJ
