Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Here's the question: Is it possible to have Excel display a .jpeg or .gif
image based on a conditional value in a cell? Example: If A1=5 then display abc.jpeg if not, display nothing. Here's the application: My end users copy and paste from a "green screen" to Excel. Excel manipulates the data and creates a sheet that can be printed out and reviewed with our clients. In this case, the "green screen" has an indicator to designate whether our client is a Five Star Dealer or not. I know that I can reference a cell to display "Five Star Dealer" but it would much cooler if I could use the Five Star logo. Even better, is there a way to change the formatting of a line chart to conditionally insert the Five Star logo? Thanks in advance for any help/suggestions that may be offered. SBH |
#2
![]() |
|||
|
|||
![]()
You'll have to use VBA to do this. You may be able to adapt the
technique here http://www.mcgimpsey.com/excel/lookuppics.html Perhaps something like: Private Sub Worksheet_Calculate() Me.Pictures.Visible = False With Range("A1") If IsNumeric(.Value) Then _ Me.Pictures("abc").Visible = .Value = 5 End With End Sub In article , "sbhogle" wrote: Here's the question: Is it possible to have Excel display a .jpeg or .gif image based on a conditional value in a cell? Example: If A1=5 then display abc.jpeg if not, display nothing. Here's the application: My end users copy and paste from a "green screen" to Excel. Excel manipulates the data and creates a sheet that can be printed out and reviewed with our clients. In this case, the "green screen" has an indicator to designate whether our client is a Five Star Dealer or not. I know that I can reference a cell to display "Five Star Dealer" but it would much cooler if I could use the Five Star logo. Even better, is there a way to change the formatting of a line chart to conditionally insert the Five Star logo? Thanks in advance for any help/suggestions that may be offered. |
#3
![]() |
|||
|
|||
![]()
Thanks for the help.....
I don't know much about Visual Basic, but I've always wanted to learn more - maybe now's the time. Thanks again for the help and have a great week. SBH "JE McGimpsey" wrote: You'll have to use VBA to do this. You may be able to adapt the technique here http://www.mcgimpsey.com/excel/lookuppics.html Perhaps something like: Private Sub Worksheet_Calculate() Me.Pictures.Visible = False With Range("A1") If IsNumeric(.Value) Then _ Me.Pictures("abc").Visible = .Value = 5 End With End Sub In article , "sbhogle" wrote: Here's the question: Is it possible to have Excel display a .jpeg or .gif image based on a conditional value in a cell? Example: If A1=5 then display abc.jpeg if not, display nothing. Here's the application: My end users copy and paste from a "green screen" to Excel. Excel manipulates the data and creates a sheet that can be printed out and reviewed with our clients. In this case, the "green screen" has an indicator to designate whether our client is a Five Star Dealer or not. I know that I can reference a cell to display "Five Star Dealer" but it would much cooler if I could use the Five Star logo. Even better, is there a way to change the formatting of a line chart to conditionally insert the Five Star logo? Thanks in advance for any help/suggestions that may be offered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
File asks to update when no links were created | Links and Linking in Excel | |||
Getting a file and Saving a File | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |