أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
Excel's conditional formatting options allow you to apply different formatting options, such as background color, borders, or font formatting to data that meets certain conditions.
Overdue dates, for example, can be formatted to show up with a red background or a green font color or both.
Conditional formatting is applied to one or more cells and, when the data in those cells meet the condition or conditions specified, the chosen formats are applied.
Starting with Excel2007, Excel has a number of pre-set conditional formatting options that make it easy to apply commonly used conditions to data.
These pre-set options include finding numbers that are above or below the average value for the selected range of data.