A dialogue box will appear where you can define the rules.
In the ‘Column’ drop-down field, select which values (columns) you want to use for a rule.
Use ‘Condition’ to select the logic to be applied, e.g. greater than or less than, etc.
In the ‘Value’ field, specify the value to be compared.
In ‘Background color’, select the color to be used.
In ‘Text color’, specify the color for the text.
With ‘Apply to the whole row’, specify whether the background color should be applied to the entire row or only to the cell.
You can define additional rules with the plus symbol.