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