Last seen: May 15, 2025
Hi Sarfraz, Please see the attached file. It comes down to your formula and the order of the formatting rules in the rule manager. As explained in ...
Ah, ok. Thanks for clarifying
Hi Sarfraz, I use that type of conditional formatting in my Project Management Dashboard. Here is a specific tutorial on just the Excel gantt chart...
Hi Courtney, Welcome to our forum! Your image didn't upload. You need to click the 'start upload' button after selecting the file and then wait ...
Hi Steve, Correct, you must aggregate the data by county for Map charts, but they aren't compatible with PivotTables. However, you can do this with...
Hi Sarfraz, If you have Microsoft 365 or Excel 2021, you can use XLOOKUP to find the last value in column E: =XLOOKUP(1E+100,E5:E20,E5:E20,,-1,2...
Hi Peter, I agree, this is very inefficient, and a lot of INDIRECT functions used like this can slow Excel down. I would use Power Query to gather ...
Hi Peter, This functionality is only available in Excel 365 or in Excel Online. You would need to save the file on OneDrive to enable sharing of th...
Hi and welcome to our forum! It sounds like your data is in the wrong layout. You shouldn't have separate sheets/tables for each month's actuals. I...
Hi Peter, Thanks for sharing your file. I'm not sure I follow what you want. I can see the formulas you've tried, but these don't show me what answ...
Hi Sarfraz, Yes, you can create a to-do list with Excel. You could use conditional formatting (lesson 5.13) to highlight due dates that are approac...
Hi Mesa, Welcome to our forum! Your file did not upload. After selecting the file, you need to click the 'Upload' button and then wait for the g...
Thanks for the file, but it's not clear what you want. Also, the data in the file is not in the correct layout for a PivotTable, which might be why yo...
Hi Tan, Your data is in the wrong layout which is resulting in the wrong approach. You should use Power Query to unpivot the month columns, then yo...
No, the link is explaining what a Pivot Cache is so that you have a better understanding of how PivotTables work in the background. There's no solu...