Conditional formatting is formatting that Excel automatically applies to selected cells if a particular condition is true. Let’s say that you are a project manager for a city and you want to see which of your projects have a budget of more than $400,000.
To add conditional formatting to the Budget column, select all of the budgeted amounts, click the Home tab, and in the Styles group click Conditional Formatting. Select Highlight Cell Rules and choose the comparison phrase, “is greater than.” In the text box below the phrase, Format cells that are GREATER THAN, type 400000.
Use the default formatting, Light Red Fill with Dark Red Text, and click OK. All of the selected cells in the Budget column that are greater than 400000 will be formatted with a light red background and dark red text. This allows you to quickly see the cells that match the condition. If one of the numbers in the range of cells changes, Excel will automatically apply the formatting if the new value meets the condition or remove the formatting if the new value does not meet the condition.
You may also use a formula to set conditional formatting. Select the cells you wish to conditionally format using a formula, click Conditional Formatting on the Home Tab, click Highlight Cells Rules, and at the bottom of the list click More Rules.
In the New Formatting Rule dialog box, select the last item (Use a formula to determine which cells to format) and enter the formula in the text box below Format values where this formula is true. Click Format and select the formatting you wish to apply where the formula is true. Click OK twice to accept and exit the new conditional formatting setting.
For more information on the Business Office Systems and Support department, contact Becky Jones, Associate Dean, email@example.com 972-238-6215.