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???

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???

Here's something that might be acceptable:

Insert a column to the right of the % of Goal column

Select a cell to the right of a Goal% value.

InsertSymbol...then select a solid circle and insert it in the cell.
(Note: you'll need to change the font for that cell to match the font used
in the symbol selection window)

Then, set up a conditional format that depends on the value in the Goal%
cell to set the font color for the circle:Green for excellent performance,
Yellow for marginal peformance, and Red for bad performance.

Example: for a percent in Cell A1, the conditional format for Cell B1 would
be:

formatConditional Formatting
Condition1:
Formula Is: =(A1=0.05)
Font Color: Green

Condition2:
Formula Is: =and(A1=0,A1<0.05)
Font Color: Yellow

Condition2:
Formula Is: =(A1<0)
Font Color: Red

Is that something you can use?

Ron