How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create …

Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You …

Click in the range that contains the conditional formatting rule that you want to change. On the Home tab, click Conditional Formatting, and then click Manage Rules. Select the rule, and …

Come usare la formattazione condizionale in Excel per esplorare visivamente, analizzare e identificare criteri e tendenze.

Use formulas in conditional formatting to do more than you can with the built-in rules. For example, format blank cells, or see which salespeople are selling above average, or track who …

What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that uses formulas for text that contains rules, and then apply conditional formatting …

Sometimes duplicate data is useful, sometimes it just makes it harder to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the …

Apply the conditional format. Select the cell that contains the error, and on the Home tab, select Conditional Formatting. Select New Rule. In the New Formatting Rule dialog box, select …