Recent Discussions
What type of chart please
Hi guys, I am looking some help. Can anyone advise on what type of chart is needed (if at all possible) to present the below set of data exactly in the way I have created the below mockup. I have tried various bar/cluster/waterfalls, etc but I cannot get the data to be in the same axis format as below. Thanks Clarke
Alternative to Pivot Table in Dashboard for better UI Experience
Hi, currently I am using Excel to build a dashboard for asset management, in particular it is used to track how many items remain after someone borrow it for a particular date range. The data comes from MS Form and has been populated into Excel. I have cleaned up and transform the original data using Power Query and the final form of my data to build the dashboard look something like this. I wish the dashboard to be able to show the following part bracket in red, which represent the details of items being borrowed. Currently I am using pivot table as my solution, as you can observe above. Is there any idea or solution to enhance the overall look of the dashboard? Basically, what I want is instead of directly on the Excel grid, can this be turned into draggable table pane?
Conditional field code
Hi, I'm trying to create some conditional code as seen in the screenshot below: But when I update the field it just shows a field code saying STYLEREF I need it to insert the paragraph number from the referenced paragraph if it's above 0 and if it's zero I need it to not insert anything. Where it says "Error!*", I tried removing that and inserting "0" but this had no effect. I was wondering if someone could help me out? Thanks in advance.Fill out other cells based on selection
Hello all, brainstorming some ideas. Want to make it easier for my colleagues to fill out. Currently for review section I made it into a dropdown list so user can select from a list than typing it out every time. What i want is based on the selection in 'Review Section', I want it to populate the sample size and total. I could do a switch statement based on what was chosen but i want to see if there is another easier option. Trying something new, any suggestions are welcomed. My Org did restrict VBA so I can't use those. tyBold Duplicates (Conditional Formatting)
Hello experts I have a form based on qryLCAmends I want to bold the [LCNo] if there is a duplicate but ONLY where LCID = LCID here is what I have but it doesnt bold anything: DCount("*","qryLCAmends","[LCID]=" & [LCID] & "[LCNo]='" & [LCNo] & "'")>1 LCNo is text. I am using the "expression" in conditional formatting: Example: How can I do this with conditional formatting?"Clear Filter From" Option is Never Available
Once a column is filtered, the option to remove that filter just from that column is always greyed out in my Excel (Microsoft 365, v2604, Build 19929.20090). I have seen multiple references advising to remove protection, check for hidden columns, or ungroup workbooks. None of these apply, since I have also tested this with a new worksheet containing a single column, with nothing possibly hidden, and with no shared access. Here is a screen shot of what I see: Thanks to anyone who may have some advice on how to re-enable this feature.
Excel - COUNTIF Function
Happy Friday! I am trying to use the COUNTIF Function on a worksheet that tracks how much liquid chlorine is used at 3 different water wells each month, each well having 2 chlorine cylinders. I'm not sure if my brain is fried from reading/watching all kinds of videos for the past 3 hours and trying to follow their instructions, but any time I put in a formula, I get a pop-up saying I've entered too many arguments. Even if I enter individual cells and use only the 3 that it highlights for me (more than 3 does not highlight). I've attached a screen shot of the worksheet (Figure 1) and have highlighted the area I'm trying to figure out. As you can see, it will be for multiple dates, on multiple lines, going through to the end of the month, with the total chlorine (CL2) tallied up on the right hand side. Chlorine tanks are changed out quite often and each tank begins at 150, depleting down to 0. Figure 2 shows a screen shot of what I'm getting when trying to enter the formula. Am I misunderstanding how the formula works or am I using the wrong formula all together? Figure 1 Figure 2Conditional formatting for a whole column, based on same-row-cells, but in one single rule
I need conditional formatting, where the color of the cell in column F is changed based on the value in the cell in column W in the same row: I have done it like this: The cell F119 changes colour to orange if this is true: =OG($W$119<>"x";$W$119<>"CNG") This works fine. But I have not been able to find a way to make one rule do this for the entire column. So I have set an individual rule for each cell in column F and I have 376 rows so far. When I need to change the rule, or troubleshoot the rule, this is not operable. Also a lot of the cells have been edited with copy-paste, and now the conditional formatting is all over the place 😒 I would prefer one single rule, that checks the cell in column W in each row, and changes the colour in cell F in the same row, if the conditions are true.
Recent Blogs
- Edits made with the help of Copilot are now visible to users and collaborators, bringing transparency to the changes made in your workbook.May 12, 2026
- The ability for Copilot to better connect to your content when using a keyboard and screen readers has evolved.May 11, 2026
