I have a pivot table in Access 2007 with multiple rows and columns.
I need each row to change color based on the values in the table.
As the cells go from left to right, if they are getting lower, I need to change the row red.
If they are getting higher, I need to change the row to green.
If the numbers remain the same, no change is needed.
If possible, I would like the color change to begin at the point where the numbers start changing and continue to the right. If that is not feasible, it is fine to just change the color of the entire row.