Hi,
I am trying to conditionally format a cell based on it being outside of two values that I am obtaining using forecast.
I can achieve what I am after by doing two separate formats but I would like to achieve it with one due to the huge number of these that will be required in the final sheet.
The data is linear between the each individual point but obviously there are two linear lines in each set.
Any ideas would be appreciated.
I have added the formula I am using as text below each cell so you don't have to look in the conditional format section (there is a space at the very front).
Bookmarks