Trevor,

The current situation: I have 25 sales people and have
figured their close rate for the month. I then take the
average of all 25 sales people. In the new cell, my If
statement says: if the current close rate for Salesperson1
is less than the average, show the average, otherwise show
the current close rate. If the value in this cell changes
to the average, then I would like the color of the new
number to show in green. I'm creating a sales
presentation tool to show business owners how they can
improve their bottom line by helping their below-average
sales people come up to the average.

Although I've been working with Excel for years, it's been
ages since I've done anything with VB, and then only took
the beginner's training in VB 5.0, so I'm not sure how to
go about doing this. Any help will be GREATLY appreciated.

Tina