Question

What is conditional formatting? Write steps to use conditional formatting.​

Answer 1

Answer:

Conditional formatting allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. To do this, you'll need to create a conditional formatting rule. For example, a conditional formatting rule might be: If the value is less than $2000, color the cell red. By applying this rule, you'd be able to quickly see which cells contain values less than $2000.

To create a conditional formatting rule:

1. In our example, we have a worksheet containing sales data, and we'd like to see which salespeople are meeting their monthly sales goals. The sales goal is $4000 per month, so we'll create a conditional formatting rule for any cells containing a value higher than 4000.
3. Select the desired cells for the conditional formatting rule.
4. Selecting cells
5. From the Home tab, click the Conditional Formatting command. A drop-down menu will appear.
6. Hover the mouse over the desired conditional formatting type, then select the desired rule from the menu that appears. In our example, we want to highlight cells that are greater than $4000.
7. The Conditional Formatting menu on the Home tab
8. A dialog box will appear. Enter the desired value(s) into the blank field. In our example, we'll enter 4000 as our value.
9. Select a formatting style from the drop-down menu. In our example, we'll choose Green Fill with Dark Green Text, then click OK.
10. The Greater Than dialog box
11. The conditional formatting will be applied to the selected cells. In our example, it's easy to see which salespeople reached the $4000 sales goal for each month.

Answer 2

Answer:

Conditional formatting allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. To do this, you'll need to create a conditional formatting rule. For example, a conditional formatting rule might be: If the value is less than $2000, color the cell red. By applying this rule, you'd be able to quickly see which cells contain values less than $2000.

To use preset conditional formatting:

-Select the desired cells for the conditional formatting rule.

-Click the Conditional Formatting command. ...

-Hover the mouse over the desired preset, then choose a preset style from the menu that appears.

-The conditional formatting will be applied to the selected cells.