I have a spread sheet that ranks 197 industry groups from 1 to 197. 4
columns rank each industry group for the current week, last week, 3
month ago and 6 months ago respectively. I want to compare the rankings
and color the cells where they are ranked red, yellow and green
depending on whether the groups are moving up in rank over time.

I am looking at using the rank function along with the IF function, but
don't quite know to go about it. Am I on the right track a or there
another function that would do the job?

Ed