Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Fix touchpad problems in Windows - Microsoft Support
To find touchpad devices, select Human Interface Devices or Mice and other pointing devices, then right-click the device you'd like to update.
Change desktop background and colors - Microsoft Support
Select Start > Settings > Personalization.The preview window gives you a sneak peek of your changes as you make them. In Personalize your background, you can select a picture, a solid color, or a slideshow of pictures you create.Or you can choose Windows spotlight to see a new image from around the world every day.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Change notification settings in Windows - Microsoft Support
To change notification settings for individual senders, under Get notifications from these senders, turn a notification sender either on or off—or select a sender's name and then turn on or turn off notification banners, lock screen privacy, turn notification sounds on or off, and set the priority of notifications.
VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Change your password in Outlook.com - Microsoft Support
To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.
Applies To: Outlook.com
Scan a document or picture - Microsoft Support
The Windows Scan app can help you scan pictures or documents and save them to your PC as JPEG, bitmap, or PNG files. For more info, see Install and use a scanner in Windows.. Get Windows Scan
Turn on device encryption - Microsoft Support
In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.
Windows 10 Update Assistant - Microsoft Support
This troubleshooter assists customers whose machines are not yet updated to the latest release, Windows 10 Version 1607. This update will initially be released only to a small set of targeted customers. This set will expand over time. Windows users can start the assistant from this article.