New answers tagged

0

After reviewing the comment of teylyn, I found the solution, in cell A1 in worksheet2, I also referred to cell A1 of worksheet1; and this solved the problem. Thank you.


0

in cell A1 date of Birth in cell B1 age with the formula with the conditional formatting: =TEXT($B1,"DD/MM")-TEXT(TODAY(),"DD/MM")=0 Having age in B1, are you sure your conditional formula works? Isn't it referring to A1?? As sheet2 contains age, not date of birth, use this formula: =FIND(B1," 0 Months, 0 Days")>0


0

You can add a sheet reference to your conditional formatting formula on sheet 2 to refer to the source cell on sheet 1. =TEXT(Sheet1!$A1,"DD/MM")-TEXT(TODAY(),"DD/MM")=0


1

If you lose access to your e-mail address without any other recovery options, you might be hosed. If you did, however, set up alternate e-mail addresses or mobile phones, you can use the "Can't access your account?" link on any Microsoft sign-in page to start a process by which you can log in. From there, you can use the "Manage your account aliases" page to ...


-1

If somebody else renews the account and then setup their DNS and mail server And if they have catch all email account they would start getting your emails So even if Microsoft doesn't realize that you do not own the domain you would no longer receive new emails You might still be able to login But if the new owner realizes that there is already a ...


0

To create a new shortcut from the existing shortcut file, you can also enter this path into file explorer: shell:Appsfolder Scroll to Microsoft Edge, then and drag or right click to create a new shortcut. I used this method to put Edge in the startup folder.


72

You need a higher edition of Windows, professional or above. Windows 7 Home Premium is limited to 16 GB. This is not a hardware limit but a limit enforced by the operating system. From Memory Limits for Windows and Windows Server Releases Version Limit on X86 Limit on X64 Windows 7 Ultimate 4 GB 192 GB Windows 7 Enterprise ...


0

Found it, take a look at this page - http://windows.microsoft.com/en-us/windows/two-step-verification-faq Sign-in to the Azure Management portal At the top, right-click on your user name and select Additional Security Verification. On the proofup page, at the top, select app passwords Click Create Enter a name for the app password and click ...


0

The issue might be solved by making her account a local one: How To Create A New Local User Account In Windows 10 Access the Accounts menu - To do so click on the Start Menu search box and enter “add user”. Select “Add, edit, or remove other users” from the top of the resulting search list. Select “Add someone else to this PC”. Ignore the prompt to ...


0

I often use colors to differentiate various types of data. In a macro script, one can test for the background color of a cell, thus allowing the summation only of cells of a particular color. And perhaps another benefit would be the ability to see, at a glance, the amount of vacation or sick leave.


1

If you can, the cleanest would be to add the v or s in another column as @Jonno says. If no, I can think of 2 ways to do that: a- You could use Number Formatting (right click, Format Cell, Number tab). Creating a Custom format "v"#.0 and "s"#.0 to show v7.5 or s7.0 respectively. b- you type the v or s in front of the number in the cell and then sum them ...


-1

I prefer to webchat or speak with Microsoft when I have a problem with their products. I've always found them to be extremely willing to help.


0

I believe the error was specifically tied to corrupted Office files. Thanks to all for the suggestions.



Top 50 recent answers are included