I have a table which uses the following expression:
=sum([Last Month Forecast]-[Current Forecast])
This will give me a negative number or positive number. Id like to format the background of each cell depending on the number. I cannot use visual cues as I have THREE ranges Id like to work with. One of these ranges, being between 1 & 60.
I had worked out the expression for a basic, two part "if statement" but cannot find the right way to put "between" in the expression:
example- (which with a calculation in place of the underscores, is Ok. )