Add conditional rules by selecting a cell or range of cells, select a rule type from the dropdown menu, enter the specified parameters then click “Add conditional rule”. If cells in the specified range fit the specified condition, they will be highlighted in red.

Add Conditional Rule

Update Conditional Rule

Minimum

Maximum

Type:

Value:

Color:

minimumType:

minimumValue:

maximumType:

maximumValue:

gradient

color:

showBorder

borderColor:

showBarOnly

dataBarDirection:

useNegativeFillColor

negativeFillColor:

useNegativeBorderColor

negativeBorderColor:

axisPosition:

axisColor:

Rule(applied in order shown)

Applies to

Stop If True

Cell value between 4 and 7

=$A$2:$A$11,