133 Using formulas in conditional formatting AND Data validation list فى اكسيل

-1-

-2-

1 كتاب تعلم برنامج Excel من الصفر للاحتراف pdf مجانا
2 تحميل كتاب الإكسل للمهندسين pdf
3 كتاب مجاني شرح أكثر من 100 دالة من الإكسل
4 كتاب متقدم جدا 👌 كتاب طرق الاهلاك باستخدام دوال الاكسيل

5 كتاب عجائب الحساب العقلي رابط التحميل بأول تعليق :

 

تنزيل ملفات الاكسيل الخاص بالدرس

Sure, here is a guide on how to use formulas in conditional formatting and data validation lists in Excel:

Conditional Formatting with Formulas

Conditional formatting allows you to highlight cells based on certain criteria. You can use formulas in conditional formatting to define complex criteria.

Here are the steps on how to use formulas in conditional formatting:Select the range of cells that you want to format.

Click the Home tab.

In the Conditional Formatting group, click Conditional Formatting Rules.

Select Use a formula to determine which cells to format.

In the Format values where this formula is true box, enter a formula that evaluates to TRUE for the cells that you want to format.

Click Format.

In the Format Cells dialog box, select the formatting that you want to apply to the cells.

Click OK.

Data Validation with List

------------------------------------ ------------

Data validation allows you to restrict the type of data that can be entered into a cell or range of cells. You can use a data validation list to restrict the data to a specific set of values.

Here are the steps on how to use a data validation list:Select the cell or range of cells that you want to validate.

Click the Data tab.

In the Data Tools group, click Data Validation.

In the Data Validation dialog box, select List from the Allow drop-down list.

In the Source box, enter the range of cells that contains the list of valid values.

Click OK.

Example

Let's say you have a table of student grades. You want to use conditional formatting to highlight cells that contain a grade of 90 or above. You can use the following formula:

=B2>=90

In this formula, B2 is the reference to the cell that contains the student's grade.

You can also use data validation to restrict the grades to a specific set of values. You can use the following range as the source for the data validation list:

'Student Grades'!A2:A10

In this range, the first cell (A2) contains the value 90, and the last cell (A10) contains the value 100. This means that the only valid values for the student's grade will be 90, 91, 92, ..., 100.

I hope this helps!

Please let me know if you have any other questions.

-3-

-4-