Conditional Formatting
Hello, I am developing a conditional formatting rule that allows me to enter a specific text value, and if it matches the content of another cell, that cell will be highlighted in green. However, instead of highlighting only the matching cell, the entire selected range is being highlighted each time I enter a text value.
Excel macro VBA issues
Hey guys. - I wrote a macro, which contain other macros using Call orders. If I running the macros separately everything ok, from the main macro one of them didn't running it's like it skipped from the list. Reason unknown. -On running I can see 4 application window get visible, and those didn't connect any kind of application. Also a Clipboard error message get visible, but I get a Clipboard cleaning macro, which several times cleaning the Clipboard, so it can't be. It's like a hack, or something which I don't recognize. - One a sheets called Total, I can't use the built in group function and can't collapse the selected section so the project I working on lost functionality. I didn't make any change on that side, but previously it was useable. Thanks for help in advance. Cheers. Zsolt
Few cells in Date column is no formating
The "Date" column (E)was pulled from another excel file using xlookup. When I Try to format Date column few cells don't change at all. The cells containing dd-mmm-yyyy don't change. The cells containing 30 september 2025 changes when I format date column. I don't have issues with other columns. I tried custom formatting as well on date column but still the same few cells dont change at all. Can someone please help?
Calculate Average Up Periods and Down Periods
Good afternoon, all. I am doing an analysis on data going back to 1984 (monthly data). The data set has positive and negative numbers. I am trying to create a formula that will go through all the data points and calculate the average of all the positive data points. Also, want the same calculation for all the negative data points. How should I set that up? What is the best function to use? Thank you in advance. Regards,
What is the formula for counting each number from 1to25 that hits from each drawing?
I want to calculate the daily numbers for cash25 lotto. The numbers are drawn on Monday, Tuesday, Thursday, and Friday of each week. Six number from 1 to 25 are drawn each time. I have 157 rows and 7 columns (A-G). The first column is the date and Columns B-G are each number that was drawn. I know I need to do a count in each column of the total times each number is drawn. What is the formula I should enter? Help, please!
Movement in spreadsheet as form after enter
When using an Excel spreadsheet as a form, is there a way to move from one cell location directly to another cell location after pressing enter in the first cell? What I want to do is have the user enter the width in cell B7, hit enter, and have B9 become the "active" cell, then enter the length in B9, hit enter, and have B11 become the "active" cell, so on and so forth. Essentially I want to skip from one input cell to another without having to go through all of the rows. Not all "moves" from one cell to another would be exactly two rows down, other locations in the spreadsheet would require moves of 3 or 4 rows to get to the next "active" cell. All of my moves would be in the same column though. Thanks to all who look at this.
Celebrating 40 Years of Excel: A Journey of Impact, Innovation, and Community
🎉 Celebrating 40 Years of Microsoft Excel This year, Microsoft Excel turns 40! From its debut in 1985 to becoming the world’s go-to tool for analysis, decision-making, and creativity, Excel has shaped how we work, learn, and share insights. 📊 Excel in Pop Culture Over the decades, Excel has appeared everywhere — from TV shows to internet memes — proving it’s more than just software; it’s part of our culture. ⏳ Excel Through the Decades From the first release in 1985, to the introduction of pivot tables, charts, Power Query, dynamic arrays, and now AI-powered Excel, the journey has been remarkable. 💼 Excel’s Impact on Business For entrepreneurs, enterprises, and analysts alike, Excel has been a cornerstone of productivity, unlocking insights and driving smarter decisions. 💚 A Thank You to the Excel MVPs & Community A heartfelt thank you to the Excel MVPs and community for teaching, inspiring, and sharing knowledge with millions of users worldwide. Your passion has kept Excel thriving for 40 years. 🎂 Here’s to the Next 40 Years From formulas and charts to AI and beyond, the future of Excel is bright. Happy 40th birthday, Excel! 🎉 #ExcelAt40 #ExcelJourney #ExcelImpact
Excel formula stopped working
I have a work book with 6 sheets in it, tracking grain sales. Two sheets have stopped calculating the formula the more lines we use. I have to drag it across the cells to get it to calculate all of a sudden instead of it auto-calculating. Im not sure if its a rounding issue that causes it to stop working? I was told previously that this has happened and thats what they thought it was, but the girl at my work that created the spreadsheet, is no longer here. My boss doesnt remember how to fix it. Any ideas?
