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

- Less than

- Equal to

- Greater than

Step-by-step explanation:

First, I'll assume this question relates to Microsoft Office Excel.

From the list of given options, only Less than, Equal to and Greater than can be said to be instances of conditional formatting.

The essence of conditional formatting is to compare values of selected cells or cells with another value;

Take for instance;

- if cellB10 is less than 2

- if cellB11 is equal to 2

- if cellB13 is greater than 2

.....And so on

To access the conditional formatting tools;

- You need to highlight the cells to format

- Select Conditional Format from Styles option on the Home tab

- Select Highlight Cells Rules

- Select format type (e.g. greater than, less than, etc.)

- Enter format value and how you want it to be formatted

- Press OK