Conditional formatting can be done only against absolute value and not relative value when creating a table. This is quite misleading when we are looking at data for a set of time periods. 

The red/green up/down arrows are all showing in comparison with an absolute value that we feed in the background and not in relation to the value of previous time period. Please suggest if there is any way to do conditional formatting with relative values.