Recent Discussions
Conditional 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.
#DIVISION/0!
Hi. I have a problem (this is in Swedish) where I get #DIVISION/0! in a field in excel. The formula in the field is =AVRUNDA(MEDEL(G4:G22);2) Translated I think it is =ROUND(AVERAGE(G4:G22);2) I have tried to do as you described with =IFERROR(AVRUNDA(MEDEL(G4:G22);2),"") But I get an error message.
combine multiple text into single line of text
Hi is there a way to combine all the cells into a single cell (of text) ignoring the duplicates/repeat values. i know concatenate but that function becomes very lengthy as ill have to define every cell into the function individually. is there any other function where i simply select the entire data (like an array) and it can do the required.
Complex formulae with data model
Over the years, I have developed a significant excel data sheet which has gotten slower and slower with time. I have discovered the idea of excel's data model this week and have learnt how to import the data I need from its source CSV to the data model and I now have a power pivot which looks like what I originally had in excel. What I would like to do next, is to replicate some of the formulae I had in excel to calculate if something should be counted or not. I would not want the red one to be counted as this row would have been counted in the previous month. In excel I was using the following formula- =IF(COUNTIF(B5:M4,">0"),SUM(Patient!B5:M5*0),Patient!N5) is there a way of achieving this with the data model or would I have to hardcode this into another sheet? I was trying to avoid doing this to minimise the number of formulae... Many thanks for your help...
Can a font become 'corrupted,' and how to replace?
This refers to MS Word from Office 2019, running under Windows 10 Pro. I have a somewhat large (10MB) Word .docx I've been adding to as time permits. It has text, illustrations, pictures and captions for the pictures in text boxes. suddenly, when I open the file, some of the captions are garbled. The font I used is Arial 10pt, bold and regular. The bold is just fine, the regular is garbled. However, if I highlight the garbled text and change it to bold, italic or any other font, it appears just fine. Here is an example of what I'm talking about. First the .docx as it appears on my screen: Then if I highlight that garbled text and change it to Bold, or any other font, it looks good: If I change point size the problem persists. It's just Arial Regular that garbles, and only in this document, and . Other .docx files using that same font display fine. Also, I can take this file and open it on my other computer, which is running Office 2010 under Windows 10 Pro, and it opens properly. I do have Word programmed to embed non-system fonts in the document, so I'm assuming that Word is fetching Arial Regular to display when opening the file on this computer, and that my other computer maybe has a good Arial Regular installation, which is why it looks good there. Something else I just noticed, referring to the two screenshots that follow. Other 10pt. Arial Regular that was NOT in a text box seemed okay in this document. But on close examination, the kerning seemed a bit off. So I changed that non-text box text to another Helvetica-style font and it did look better, but then when I set it back to Arial, it was garbled too. So do I have a bad Arial Regular on this computer? If so, why don't other documents show this problem. And, most important, how do I fix it? Thanks in advance, and... HELP!
Events
Happening Now
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- Learn how we are leveraging AI to modernize our approach to change management and give you the tools, information, and processes you need to fully realize value from Microsoft 365.Apr 16, 2026
- Building in the era of AI can get very challenging. That’s exactly why we’re here to help you debug, refactor, and level up at the Microsoft 365 Community Conference, happening April 21–23, 2026 in O...Apr 15, 2026
