Highlight outliers using conditional formatting

  1. Enter an expression that determines the condition. For example, if you want to highlight all compound amounts greater than 4, enter the expression =Compound_Amount > 4.

  2. In the Format drop-down list, select the required formatting for highlighting the outliers.

  3. Save the settings.