089
استخدام المعادلات فى التنسيق الشرطى Conditional Formatting with Formulas
Conditional formatting with formulas allows you to apply formatting to cells based on the results of a formula. This can be useful for highlighting important data trends and patterns.
-----------------------------
To create a conditional formatting rule with a formula, follow these steps:
- Select the cells to which you want to apply the conditional formatting.
- Click Conditional Formatting on the Home tab.
- Click New Rule.
- In the New Formatting Rule dialog box, select Use a formula to determine which cells to format.
- Enter the formula in the Format values where this formula is true box.
- Click Format and select the formatting that you want to apply.
- Click OK.
Here are some examples of conditional formatting rules with formulas:
--------------------------------
Highlight cells with values greater than 100:
=A2>100
Highlight cells with values less than 50:
=A2<50
Highlight cells with values that are equal to a certain value:
=A2="Apple"
Highlight cells with values that are not equal to a certain value:
=A2<>"Apple"
Highlight cells with values that are between two values:
=AND(A2>50,A2<100)
Highlight cells with values that are not between two values:
=OR(A2<50,A2>100)
You can also use more complex formulas in conditional formatting rules. For example, you could use a formula to highlight cells that are above or below a certain percentage of the average value in a range.
Conditional formatting with formulas is a powerful tool that can help you to visualize your data and identify important trends and patterns.