User Profile
Virock
Copper Contributor
Joined Aug 01, 2023
User Widgets
Recent Discussions
Equation Editor Wrong Highlight Color In Dark Mode
The highlight color in the Equation Editor is not correct when using dark mode in Word. The white text is unreadable. I’m seeing posts mentioning this issue from 4 years ago. How has this not been patched? How do I fix this myself if Microsoft won't?Middle Click Scroll Selects Cells
I just started using the browser version of Excel because it's more convenient than the desktop app with Sharepoint. Immediately, I noticed that middle clicking to scroll horizontally selects the cell under the cursor. This completely wrecks my workflow because I will lose my selection. I can't feasibly use the horizontal scroll bar because... A) The spreadsheets are way too big and the scroll bar is too sensitive. B) Torture is not permitted at my company. How do I disable this bizarre behavior?Nested IFs Causing "Problem With Formula" Error
Excel is not recognizing my formula and says "there's a problem". I'm sure it's something simple and I have become blind to it. I need a second set of eyes. The spreadsheet itself is not my IP. I can make a dummy spreadsheet if necessary. =IF(EXACT(L4, "none"), IF(EXACT(N4, "none"), "NOT FOUND", IF(ISNUMBER(SEARCH("none", XLOOKUP('IB List - by Part#'!N4, Transmitters!A:A, Transmitters!H:H))) "No", "Yes")), IF(ISNUMBER(SEARCH("none", XLOOKUP('IB List - by Part#'!L4, 'II-Kits'!A:A, 'II-Kits'!I:I))) "No", "Yes"))
