027 التنسيق الشرطى القيم الأكبر من قيمة معينة أو الأصغر من قيمة معينة - شرح اكسيل

Introduction

This tutorial will guide you through the process of applying conditional formatting in Excel to highlight cells based on specific criteria. You will learn how to format cells that contain values greater than or less than a specified value, and how to work with dates in relation to today's date. This is a valuable skill for data analysis and presentation.

Step 1: Open Your Excel File

• Launch Excel and open the workbook where you want to apply conditional formatting.
• Select the range of cells you want to format.

Step 2: Access Conditional Formatting

• Go to the Home tab on the Excel ribbon.
• Click on Conditional Formatting in the toolbar.

Step 3: Select a Formatting Rule

• Choose New Rule from the dropdown menu.
• In the New Formatting Rule dialog, select Format only cells that contain.

Step 4: Set the Rule for Values Greater Than a Certain Number

• In the first dropdown, select Cell Value.
• In the second dropdown, choose greater than.
• Enter the specific value you want to compare against in the box provided.
• Click on the Format button to choose the formatting style (such as fill color, text color, etc.).

Step 5: Set the Rule for Values Less Than a Certain Number

• Repeat Step 3 to access New Rule again.
• Select Format only cells that contain.
• Choose Cell Value and then select less than.
• Enter the specific value and set your desired formatting style.

Step 6: Formatting Dates Greater Than or Less Than Today

• For formatting dates, follow the same steps to access New Rule.
• Choose Format only cells that contain.
• Select Date Occurring from the dropdown.
• Choose options such as greater than or less than, and select Today from the options.

Step 7: Applying to Dates Relative to Yesterday or Tomorrow

• Again, use the New Rule option.
• For dates relative to today, select less than and enter =TODAY()-1 for yesterday, or =TODAY()+1 for tomorrow.
• Select your desired formatting.

Step 8: Review and Apply Formatting

• After setting all your rules, click OK to apply the formatting.
• Review your data to ensure that the conditional formatting has been applied correctly.

Conclusion

You have successfully learned how to apply conditional formatting in Excel to highlight cells based on various criteria, including numeric values and dates. This skill enhances your data visualization and allows for better insights into your data trends. For further practice, consider exploring additional conditional formatting options and experimenting with different criteria to see how they impact your data presentation.