To turn on the adverse/favourable variance formatting, go to Settings, Organisation settings, then turn on the toggle "Show favourable / unfavourable variances" under "Organisation values."
Once turned on, favourable variances show as green and unfavourable variances show as red. This means that a positive revenue variance will be green, but a positive cost variance will be red.
Note: when this option is turned off, variances all remain black, with no colour coding.
Below is an example of a report in which favourable / unfavourable variance formatting has been turned on. You can see that where Budget is below actuals in sales, the negative variance is red, but where Budget is below actuals in costs, the negative variance is green. (Totals all remain in black).
Once variances are set up, you can adjust whether they are neutral (black) or coloured (red or green) - you can also select which direction is green. To do this in reports and charts, ensure that the line item is set up as a metric, then edit the metric settings. If not already set up as a metric, you can set the line item or series to equal a new metric. This can be done within the Metrics Library (within the load data tab). Use the metric edit function to select the variance settings, as shown below.