Visualise difference between two identical tables
Hi!
I am pretty much using Excel for the first time in my life, and my deadline is tomorrow. I tried to find a solution online, and I found some results about comparing tables, but I honestly didn't understand if that was even what I'm looking for... If I had a few more days I might be able to figure it out on my own, but right now I'm running out of time.
Here's my situation: I have two big tables with identical labelling (they're comparisons of data between two different years). They're formatted as tables, like in the mock-up just much larger. The numbers in the mock-up don't make sense, don't mind them.
I want to add difference markers to the second table, something like those arrows or percentages I manually added in the mock-up. I'm hoping there's some pre-programmed function I just can't find?
Ideally the solution would be through conditional formatting, because adding new rows in the middle would muck up everything below those two tables and take ages to fix...
Percentages would be great, but arrows would be better than nothing.
Thank you!