Excel Conditional Formatting

The Conditional Formatting function in Excel allows you to:

• Automatically apply formatting based on specific rules or conditions being met.

• Automatically apply highlighting to selected cell ranges based on specific rules or conditions being met.

• Automatically change the font of selected cell ranges based on specific rules or conditions being met.

• All of the options listed above are correct.

Where can you find the option to set Conditional Formatting rules?

• Under the Home tab on the Ribbon in the Styles group.

• Under the Formulas tab on the Ribbon in the Formatting group.

• Under the Insert tab on the Ribbon in the Formatting group.

• Under the Page Layout tab on the Ribbon in the Styles group.

Which of the following formatting options can you set for Conditional Formatting rules?

• Light Red Fill With Dark Red Text, Yellow Fill With Dark Yellow Text and Green Fill With Dark Green Text.

• Light Red Fill With Dark Red Text.

• Light Red Fill, Light Yellow Fill and Light Green Fill.

• You can apply any of the formatting detailed in the options above as well as number, border, shading and font formatting.

Study the screenshot above. Several Conditional Formatting rules have been applied to this worksheet. How can you ascertain which rules have been applied and where?

• Click on the Conditional Formatting button in the Styles group and select Manage Rules.

• Right click in an area of the worksheet that contains conditional formatting and select Format Cells.

• Click on the Conditional Formatting button in the Styles group and select More Rules.

• None of the options listed above are correct.

How can you remove conditional formatting, such as the colored font and blue, pink and green shading, from the worksheet?

• Select the worksheet or range of cells, right click and select Format Cells from the menu list. From here you can remove formatting.

• Select the worksheet or range of cells, click on Conditional Formatting and select the Clear Rules option.

• Select the worksheet or range of cells, click on Delete in the Cells group and select Delete Formatting Only.

• All of the options listed above are correct.

Top/Bottom Rules allow you to apply conditional formatting to cells that fall within the top or bottom numbers or percentile. How many items will it allow you to include in the rule?

• The top or bottom 10 items or top or bottom 10% only.

• The top 10 items and top 10% only.

• The top or bottom 100 items only.

• Any logical number of items or percentages in top or bottom value frames.

Which of the following functions can you NOT perform using the Conditional Formatting option?

• Insert icons that visually display the ranking or rating of values in a selected range.

• Apply conditional formatting to dates that fall within specified date ranges.

• Use conditional formatting to highlight any duplicate values or data in a worksheet.

• Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.

How do you change the range of cells that a Conditional Formatting rule applies to?

• You cannot change the range, you have to clear the rule first and then reapply it.

• In the Conditional Formatting Rules Manager dialogue box, edit the cell range for the rule in the Applies To section.

• Select the cell range and reapply the rule. This will automatically delete the previous rule and create a new one.

• Right click the cell range and select Update Conditional Formatting Rule from the menu list.

Immediately after applying a conditional formatting rule, you realize it is a mistake. How do you fix it? Choose the best answer:

• You have to clear the rule you created by going to the Conditional Formatting Rules Manager dialogue box and deleting the rule.

• You have to clear all rules that have been applied to the worksheet or selected range, by clicking on the Clear Rules button.

• You can simply press the Undo button or use the shortcut Ctrl+Z to undo the last rule created.

• You can right click the area where the conditional formatting rule has been applied and select Clear Rule from the menu list.

You can check the conditions against __________ when applying conditional formatting.

• Cell Value

• Formula

• Both A and B

• None of the above