Hi

i played with this recently for another poster and as far as i could tell
(using the info, on the website below) and a bit of trial & error you need
three pictures per cell with an IF statement to determine which of the three
pictures you want displayed for each person. Depending on the number of
sales people this could be a lot of work. I didn't find any way of
"short-cutting" the process - but you never know, someone else may have
better idea.

Check out ... http://www.mcgimpsey.com/excel/lookuppics.html for details ..

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"bonita0914" wrote in message
...
I am working on an Excel project that is dealing with sales and the
reaching
of goals. In the worksheet, if a person meets their goal and exceeds it by
5%
or greater, I need a red light to appear, if 5% or below red and if in
between, yellow. I know that conditional formatting will allow the cell to
turn a color, but I need just the circle (the autoshape I have inserted)
to
turn a color. However the conditional formatting turns the whole cell a
color
no matter what I do. If I try to insert these red, yellow and green lights
on
a separate worksheet and then create a link between the 2 with a formula,
it
just does not recognise the circle at all. Is it impossible to create a
formula that results in the pasting of these red, yellow or green
circles???