Conditional Formatting based on Separate Column
HI, I'm new to excel formulas and conditional formatting! I'm using a spreadsheet to track new hires, and I'm trying to figure out how I can use "less footsteps" and not have to apply conditional formatting to every.single.cell. in a column..... I'd like to be able to type in something into my "L" column, and have the "D, M, N & O" columns to change color based on what is typed. I know that I can go in and individually click on the cells and then conditionally format them, but I'm going to have well over 300 different entries that I'm going to be working with. I'd love to get that time back! I've tried searching on this forum but can't find what I'm looking for....Thanks for your help! I've attached a snip to show what I'm working with. 🙂
How to create a sub list from a master list
I've set up a master list of names and performance data on one sheet in a workbook, there are 16 unique names in the master list and 200 entries in the master list in total I want to set up sub sheets within the workbook to display the same list layout as the master sheet list but each sub sheet only showing all the results for each of the unique names that appear in the master list I need all the sub sheet lists to populate automatically once all the entries have been updated into the master list and I can't have any spaces appearing between the results that appear in the lists on the sub sheets Thanks in advance
Help with Excel functions
Hello Community, I'm in desperate need of help with a problem for my accounting class. I've attached the file. The problem is: In cell H6, enter a formula to determine any discount that should be applied. If the payment method was Express Miles or Rewards, the customer should receive the discount shown in B42. If no discount should be applied, the formula should return a zero. Use the named range for cell B42, not the cell address, in this formula. Copy the function down the column to cell H32. I've tried all types of variations of the =IF function and I got nowhere. Thanks for the help.
Excel Tower Defense
Here's an updated version of my Excel Tower Defense game as mentioned in the recent Excel AMA on Reddit. Backstory: Shortly before Office 2010 shipped, the Excel test team was instructed to take a couple days to make solutions that could stress test some of the new features. Because I enjoy playing tower defense style games I decided to make one in Excel using a mixture of many of the new features in that release (Slicers, cross-sheet dependent Conditional Formatting, the AGGREGATE function, and Sparklines). As an added challenge given my familiarity with calc in Excel, I wanted to see how much of the game could be written without using any macros. I spent roughly 4 work days making the first playable version, including significant time spent discovering, reporting, and working around a number of product bugs along the way so that I could complete the game and also get the product bugs fixed before shipping. After the initial version was up and running, I gave it another 8-16 hours of hobby time adding features and fixing bugs in my solution, such as adding localizability and making mouse UI more robust. In the years since then, I’ve probably only looked at it for an hour or so per year, fixing small issues and adding support for sheet zoom levels and non 96dpi Monitors. Due to the internal popularity, one of our PMs at the time offered to write up a blog post about it and another Missile Command game created by a coworker around the same time. You can find that blog post at https://www.microsoft.com/en-us/microsoft-365/blog/2010/07/27/how-its-made-tower-defense-a-game-in-excel-2010/. Since the images appear broken you may have more success reading this copy from archive.org (https://web.archive.org/web/20100730035318/http://blogs.msdn.com:80/b/excel/archive/2010/07/27/how-it-s-made-tower-defense-a-game-in-excel-2010.aspx). We also published a couple YouTube videos going behind the scenes of how they work. The video for Tower Defense can be found at: https://www.youtube.com/watch?v=SFzi0Xs5_vw While you may notice that the file contains macros, these are only used to enable mouse UI (hover and click). To play the game without enabling macros, simply Unhide the “Game” sheet and then after switching to it, use the keyboard to select cells. Pressing F9 to recalculate will trigger the next frame, treating the active cell as a mouse click. For best results, please make sure to close any other books before opening this one and don’t open any other books at the same time.Auto Select data one by one from data filter of a pivot table using VBA MACROS
Hi!!! I need some help to write a VBA macro code to auto select a data one after another from a data filter field of a pivot table. Sheet 1 consists of all datas and Sheet 2 consists of Pivot table and Sheet 3 consists of a report format. Had tried macro, but whenever Sheet 1 data is updated, while running a macro with updated pivot data filter, it picks the previous set of datas. Could anyone please help. Thanks and Regards SridharWorking with web services in Power Query/Excel and Power BI
You can use web services as data sources in Power Query/Excel and Power BI but to do so you need write some M code. In this session, you'll learn how to use the M Web. Contents() function to call web services to make GET and POST requests, how to handle authentication, how to generate JSON to pass to a web service, how to make sure your code runs successfully after it has been published to the Power BI service, and many other useful tips and tricks.
Functions Translator Add-in
Hi Folks, Microsoft Garage announced a new Excel add-in which is very helpful to finding a correct function name in your local language in case you have a localized version of Excel. The new add-in is called Functions Translator, you can get it from https://appsource.microsoft.com/en-us/product/office/WA104381504, or directly from the Excel through the https://support.office.com/en-us/article/get-an-office-add-in-for-excel-d3df5854-0a4e-4169-9cc3-25177a288d3d It supports Excel 2013 SP1 or later. As described in the overview section of the add-in page, the Functions Translator Add-in supports your work in all localized versions of Excel in the following ways: Enables you to translate all functions between all supported languages Enables you to translate complex formulas between all supported languages Provides you with bi-lingual dictionaries with function definitions (in English) for function lookup Enables you to give feedback on translations It can help some experts here to translate their suggested formulas if the help applicant works on a localized version of Excel. Haytham
