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
Get apps from Microsoft Store on your Windows PC
If you're moving from a Windows 7 or Windows 8.1 PC to a new Windows device, you'll find that the best way to get apps and games is through Microsoft Store.
Download Internet Explorer 11 (Offline installer) - Microsoft Support
Microsoft Edge is the browser recommended by Microsoft. Support for Internet Explorer ended on June 15, 2022. If any site you visit needs Internet Explorer 11, you can reload it with Internet Explorer mode in Microsoft Edge.
Upgrade Windows Home to Windows Pro - Microsoft Support
Important: The following steps apply only to devices currently running an activated copy of Windows 11 Home.If you’re not activated, we recommend you activate Windows 11 Home first. For more info, see Activate Windows.
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
Keyboard shortcuts in Windows - Microsoft Support
Do you want to learn how to navigate Windows using keyboard shortcuts? Whether you need to switch between apps, open the command prompt, or perform any other tasks, you can find a full list of keyboard shortcuts in Windows on this webpage. Discover how to save time and improve your productivity with these handy tips.
Fix Bluetooth problems in Windows - Microsoft Support
Before you start. Check these things before you start troubleshooting Bluetooth on your device: Check your product information. If you’re setting up a new device and Bluetooth is missing, check the product specifications to make sure it has Bluetooth capabilities.
Finding your BitLocker recovery key in Windows - Microsoft Support
Where can I find my BitLocker recovery key? BitLocker likely ensured that a recovery key was safely backed up prior to activating protection. There are several places that your recovery key may be, depending on the choice that was made when activating BitLocker:
Switching out of S mode in Windows - Microsoft Support
Windows 10 in S mode is designed for security and performance, exclusively running apps from the Microsoft Store. If you want to install an app that isn't available in the Microsoft Store, you'll need to switch out of S mode.
Fix Ethernet connection problems in Windows - Microsoft Support
On your home router. Try these things first to help you fix or narrow down the connection problem. Check the Ethernet cable and connection.Make sure the Ethernet cable is securely plugged into the Ethernet port on both your router and Windows 10 PC.