top of page

You are learning Conditional Formatting in MS Excel

How do I create conditional formatting based on a formula result (TRUE/FALSE)?

Here's how to create conditional formatting based on a formula result (TRUE/FALSE) in Excel:

1. Select the cells: Choose the range of cells where you want to apply the conditional formatting based on the formula.

2. Go to Conditional Formatting: Navigate to the "Home" tab on the Excel ribbon. In the "Styles" group, click the dropdown arrow under "Conditional Formatting."

3. New Rule: Select "New Rule" from the dropdown menu. This will open the "New Formatting Rule" window.

4. "Format values where this formula is true": Under the "Select a Rule Type" section, choose the option "Format values where this formula is true."

5. Enter your formula: In the box labeled "Format values where this formula is true," enter your formula that will evaluate to TRUE or FALSE for each cell.

- Example: You can use logical operators like `=A1>B1` (TRUE if A1 is greater than B1, FALSE otherwise) or reference other cells with your logic.

6. Set the formatting: Click the "Format..." button to choose the formatting you want to apply to cells where the formula evaluates to TRUE. You can change font color, fill color, borders, or other formatting options.

7. Click OK: Once you've set your formula and chosen the formatting, click "OK" to close the "New Formatting Rule" window.

Now, your selected cells will have the conditional formatting applied. Any cells where the formula evaluates to TRUE will display the formatting you chose.

bottom of page