Forum Widgets
Latest Discussions
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
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
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.
Excel Macros Issues
Hi all, A few years ago, a friend wrote a Macros for an excel sheet we use to populate an action plan. The concept is very simple. The Macros goes through the tab and pulls relevent cells through to an another tab creating an action plan. Each item goes under a heading and creates a new line. This has worked like a dream for the last 5 years. Just recently, the macros has started throwing up errors when i run it. Its having issues with Row Height, and doesn't finish running the script, and Excel just hangs. I've replicated this issue on a number of computers, new and old, and tried to swap between Mac and PC. This issue remains the same. The only commonality is the latest version of Excel. Unfortunately rolling back a version is not an option. Have MS updated something that would affect the way this Macros works? Can anyone suggest a solution? Any assistance is appreciated. Many thanks D.
