Tina,

You can also build a regular macro with a loop, or better yet a change event
macro behind the sheet.
Use If statements or Select Case to determine the shading of the cell.

--
sb
"Tina" wrote in message
...
I have a spreadsheet that shows the current situation of
25 sales people in an organization, and then finds the
average of certain information. I then show how the
company's situation can be improved by helping salespeople
with below average numbers come up to the average. I'm
using If statements to show improvement if the salesperson
is below average, and how my boss has asked me to have the
spreadsheet automatically show any information that is
changing (i.e. the new figures if a salesperson is brought
up to the average) in green to make changes stand out.

Because an improvement is only made if a person is
currently below average, I can not change the color by
using conditional formatting. Is there a way to
programmatically change the color of the information in a
cell if a certain condition is met?