J Jorgensen
New Member
- Joined
- Nov 18, 2006
- Messages
- 4
I've been working on a project for work and making great progress, but now I've hit a roadblock. So some advice would be really appreciated.
I need to display a different embedded object (bitmap) depending on the value in a cell, next to or near the cell.
I've pasted the embedded objects in a separate worksheet from a Word file.
There are nine different potential values which correspond to nine different embedded objects. Or a range of values indicating either LOW, MEDIUM, or HIGH, for two different variables.
I was hoping to use an IF function, but I can't find a way to make it work. Conditional formatting of the cell won't work either.
I suspect the LOOKUP functions might help me, but I've never used them before.
And unfortunately, I've never done any programming.
Thoughts?
I need to display a different embedded object (bitmap) depending on the value in a cell, next to or near the cell.
I've pasted the embedded objects in a separate worksheet from a Word file.
There are nine different potential values which correspond to nine different embedded objects. Or a range of values indicating either LOW, MEDIUM, or HIGH, for two different variables.
I was hoping to use an IF function, but I can't find a way to make it work. Conditional formatting of the cell won't work either.
I suspect the LOOKUP functions might help me, but I've never used them before.
And unfortunately, I've never done any programming.
Thoughts?
