Hi there

I was wondering if anyone can help with this problem.

I have a spreadsheet that will contains a column for rank, name, points and
difference in the first sheet called Monday through to the 7th sheet called
Sunday.

The purpose of the spreadsheet is to show the points for 500 agents that
they have got so far in total. What I need to do is to highlight the agents
whose points have either stayed the same as the day before or have lost
points and highlight them. This would be fairly straight forward for me if it
wasnt for the fact that the agents themselves will change position and so a
simple just minus formula wont work.

Sheet Monday


Rank Name points Difference
1 Ian 10000
2 Steve 9000
3 Chris 8000
4 Peter 7000
5 Leo 6000
6 Gus 5000
7 Phil 4000
8 Linda 3000
9 skinner 2000
10 Lucy 1000


Sheet Tuesday
Rank Name points Difference
1 Ian 110000 100000
2 Steve 9000 0
3 Peter 8900 1900
4 Chris 8800 800
5 Gus 6200 1200
6 Leo 6000 0
7 Phil 3789 -211
8 Linda 3000 0
9 Lucy 1020 20
10 skinner 892 -1108


If this is possible I would appreciate any help with the formulas if you
could provide me with the basic formulas then I could enter in all the agents
names etc. This could be to complicated for formulas and may require a macro
instead.