You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.

You can use conditional formatting to highlight cells that contain values that meet a certain condition, or format a whole cell range and vary the exact format as the value of each cell varies.

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 …

In Excel, from the Home tab, click Conditional Formatting > New Rule. Next, select the “ Use a formula to determine which cells to format ” option, enter your formula and apply the format of …

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 …

You can use conditional formatting to highlight cells that contain values which meet a certain condition. Or you can format a whole cell range and vary the exact format as the value of each …

Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Point to Icon Sets, and then click …

Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Point to Icon Sets, and then click …

Before you continue saving the workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or …

If the specified conditions are true when a user fills out a form that is based on your form template, the conditional formatting is displayed. You can use conditional formatting to apply bold, …