How do I colour the background of negative Sales Variance numbers in a table

[#1]

Hello everybody,

I've been trying to colour the background of negative Sales Variance % in a table and it has worked in other tables before, but not this time. This is the table  where I want to colour the background red (Sales Variance%):

The expression for Sales Variance % looks like this:

Sum({$<Year={$(=Max(Year))}, Mon={$(=Month(Today()))}>}Sales)/

Sum({$<Year={$(=Max(Year)-1)}, Mon={$(=Month(Today()))}>}Sales) - 1

Can anyone tell me how I can write an expression that makes the colour in the background red?

Sincerely,

Betty Habtemariam

[reddy-s]

Glad It helped!