![]() After, in any Office application go to the Help menu and choose Check for Updates to launch the AutoUpdate app.Open the App store and click on the Updates button. Make sure your Mac has a working internet connection, then: ![]() If it is any other version, please do the following, then test again.Įnsure your Mac and Office have the latest updates. Please go to the Excel menu and choose About Excel and see which version you have. Doesn't work, the formulas are screwed up again. Went to Conditional formatting, went to 'Show formatting rules for: This sheet". "I" to select the whole column, go 'Conditional formatting', set my formats and 'applies to:" using this formula (generated by Excel itself after selecting column I: "Sheet1!$I:$I".įine, right? Now I go to the next row and put in the same request number to test and guess what, it stays black on white. ![]() I have the table with some data now so I click on the column header letter, e.g. Things wouldīe peachy if it wouldn't go sideways EVERY SINGLE TIME. To avoid this I've utilized the conditional formatting for duplicates meaning whenever a number shows up again it marks it red so I know it has already been logged. Now, sometimes happens that the same request comes in again a few days later. New one comes in a new row, where I store the name, request number, issue category, etc. I have a very frustrating issue: I have my xlsx what I use as a sort of a tracker to track some requests.
0 Comments
Leave a Reply. |