Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.

Calculate the difference between two dates. Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following.

Select the correct link for help with canceling a Microsoft 365, Microsoft Copilot Pro or an Xbox subscription. For all other subscriptions, follow the steps in the Cancel other Microsoft subscriptions section below.

Turning off Microsoft Defender Firewall could make your device (and network, if you have one) more vulnerable to unauthorized access. If there's an app you need to use that's being blocked, you can allow it through the firewall, instead of turning the firewall off.

Select in the toolbar of PowerPoint and OneNote to start using the desktop app, and in Word select the Editing dropdown first and then select. To export your Word document or Excel workbook to PDF format on iOS tap the. Portable Document Format (PDF) preserves document formatting and enables file sharing.

The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.

Before you send an Outlook email message or share a Word document, Excel spreadsheet, PowerPoint presentation, or OneNote notebook, run the Accessibility Checker to make your content easier for people with disabilities to read and edit.