Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bonita0914
 
Posts: n/a
Default Can an Excel formula be created to paste a picture in a cell?

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???
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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



  #3   Report Post  
Ron Coderre
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why does Excel 2003 flip picture objects in a document created in. Don Excel Discussion (Misc queries) 1 March 10th 05 09:41 PM
Copy and Paste from Excel to powerpoint the pix is Truncated Alicia Excel Discussion (Misc queries) 0 March 4th 05 03:47 AM
Paste table from excel to word Stephen Excel Worksheet Functions 0 January 22nd 05 12:15 PM
How do I view the actual numeric value of a formula in Excel 2002. Excel Function Help Excel Worksheet Functions 0 January 13th 05 11:07 PM
How do I password protect cells in a spreadsheet created in Excel [email protected] Excel Worksheet Functions 0 November 22nd 04 10:21 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"