Question

What are the options available to select 'Minimum' and 'Maximum' type while changing conditional format?

Hint:

Five options exist: Lowest and Highest Value, Number, Percent, Percentile and Formula. Percent and Percentile accept values from 0 to 100.

Answer 1

Step 1: The setting:
When we change a conditional format, Excel asks for a Minimum type and a Maximum type.
Five options are available. We take them one by one.

Step 2: Lowest Value and Highest Value:
To format the lowest and highest values, select Lowest Value and Highest Value.
In this case we do not enter the minimum and maximum values.

Step 3: Number:
To format a number, date or time value, select Number.
Then enter a minimum and a maximum value.

Step 4: Percent:
To format a percentage, select Percent and then enter a minimum and a maximum value.
The valid values here are from 0 to 100.

Step 5: Percentile:
To format a percentile, select Percentile and then enter a minimum and a maximum value.
The valid percentiles are from 0 to 100.

Step 6: Formula:
To format a formula result, select Formula and then enter a minimum and a maximum value.

Final Answer:
The options are Lowest Value and Highest Value, Number, Percent, Percentile and Formula.