Question

What are examples of criteria used in conditional formatting? Check all that apply. less than equal to added to divided by greater than multiplied by

Answer 1

Answer:

• Less than

• Equal to

• Greater than

Explanation:

Considering the listed options, the criteria used in conditional formatting are Less than, Equal to and Greater than

To make use of conditional formatting, follow the highlighted steps

1. Highlight cells that you want to format

2. Goto Home tab -> Styles -> then select Conditional Format

3. Select Highlight Cells Rules

4. Select the format type (this is where you get to pick either of greater than, equal to less than, etc.)

5. Enter the format value and how it is to be formatted

6. Press OK