Question

Which criteria are available when setting a new rule using conditional formatting? Check all that apply.

a) between
b) greater than
c) not equal to
d) multiplied by

Answer 1

In conditional formatting, the criteria for setting up new rules include 'Between', 'Greater than', and 'Not equal to'. 'Multiplied by' is not a valid criterion but an arithmetic operation. Therefore, the correct options are a), b) and c).

Step-by-step explanation:

When setting up a new rule for conditional formatting in spreadsheet applications like Microsoft Excel or Sheets, specific criteria are used to determine how cells are formatted based on their values. The available criteria include:

• Between: Highlights the cells where the value is within a specified range.
• Greater than: Formats cells where the value is more than the specified number.
• Not equal to: Targets cells whose value does not match the specified criteria.

It's important to note that the option 'multiplied by' is not traditionally a criterion in conditional formatting; instead, it's an arithmetic operation that can be used in formulas.

Therefore, the correct options are a), b) and c).