built

I am looking to highlight any dates that passed, however, when I use the built in format it highlights the blanks as well. When I used if($n6<=today(),"true","") it does the same thing. My goal is to just highlight any dates that are today's date and past, without the blanks being highlighted as...

Is it possible to highlight the entire row if 1 cell equals a specific value using the Conditional Formatting feature built in?

Hi, I am relatively new to Power Query in Excel, I am really enjoying it though and can't believe I didn't pick up on years ago. Anyway, that aside, I've built a number of spreadsheets with a number of queries within each that automate a lot of my reporting and tracking activities. The queries...

Greetings, I have a workbook that is very very slow to open. The details: The workbook is very similar in structure to other workbooks that don't share this "slow to open" issue. The workbook has quite a few formulas built into the sheet. Not sure how to proceed...:eeek:

Hi Any idea how may built in classe/objctsi vba? thank you so much.

I created an addin that works fine. I wrote a bunch of code and assigned them to buttons. But I would like to add some buttons using built in functions like Add Row, Delete Row, Hide Row. How do I refer to these built in commands? Here is a line of my XML code: <tbody> <button...

I wonder if you guys can help me (once again). I have a userform that is used for data entry and would really like to have the functionallity to have displayed the data from the last record and then then option to click "forward or back" to see the other entries. Once on them, i would like to...

Hello ALL any help would be great Mini Report Tab in E3 i would like a formula to work out the amount of parts that has been built between a time of 06:30 - 14:30. but specific for the part numbers that appears in in column A

Just like the title says. I have a COUNTIFS formula I built in pieces and glued together using cell concatenation. The formula works just fine, but I need to click into each individual cell, and hit enter, for it to calculate. I have 16K cells. How do I force XL to look at it as a formula and...

Hello, I have built a VBA form in Excel. I want it to have some similar functions as the built in form. Does anyone know the coding to the built in Form? On the left side of the form it has the 1 through 600 (number of entries) and then the next and previous buttons. I have the Clear, Add...

Im trying to create a chart that has 2 different data types? Along the bottom axis is Time e.g. Week 1, Week 2, Week 3 ect. and along the left side axis I have the number of panels built This works great as a line chart and usually have between 350 to 600 panels built each week. What I...

I've built a spreadsheet which I'd now like to roll out for simultaneous use by individuals throughout the business. It's built on Excel 2016, & I know I have access to Office 365 (although I've not actually used it yet). Is there a way to convert a 2016 to 365? for use in this manner? Thanks Jon

hi in my sheet, I have some pivotables which exact common source data but when I create slicer connection I see just the current pivottable. please, how can I fix it? (I ensured it's same source data, I built the slicer again, I tried built slicer to each pivottable and after try connect them)...

Hi All, I'm having some troubles calling the value in a dictionary, I assume it's a simple syntax issue so hopefully someone will be able to educate me easily enough. I'm also not 100% sure that a dictionary is the best/easiest way to go about doing what I'm doing, so I'm open to alternative...

I feel this should be easy, but having a bit of a mental block this morning I have weeks in coulmns and associated build qtys for those weeks - say 10 per week I also have sales orders which may be a qty of 50 - I want to find when the qty of 50 is built and then return the date or weeknum...