After a conditional formatting rule is created using the ____ dialog box, the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box. a. Report Rules Manager b. Conditional Formatting Manager c. New Formatting Rule d. Field Conditions Formatting

Answered on

c. New Formatting Rule

When you create a new conditional formatting rule in applications like Microsoft Excel, you would use the "New Formatting Rule" dialog box to define the criteria for how cells should be formatted based on the conditions that you set. After the rule is created, you can manage all your existing rules in the "Conditional Formatting Rules Manager" dialog box.

Extra: Conditional Formatting is a feature in applications like Microsoft Excel that allows you to apply specific formatting to cells that meet certain criteria. It is a way to visually highlight important data, identify trends and exceptions, and make a spreadsheet more readable.

To use conditional formatting, you typically follow these steps:

1. Select the cells you want to apply formatting to.

2. Go to the Home tab, and choose "Conditional Formatting" in the Styles group.

3. Click on "New Rule" to open the "New Formatting Rule" dialog box.

4. Choose the type of rule you want to create (e.g., format cells based on their values, only format cells that contain text, dates, or occurrences of a particular value, etc.).

5. Set the criteria for your formatting rule.

6. Choose the format (font style, color, fill, etc.) that you want to apply when the conditions are met.

7. Click OK to save the rule.