Chris Davison
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 1,790
Hi all,
I know how to put a pic as a comment background (ie family photo, or a landscape etc etc when the mouse hovvers over the cell)
is it possible to make it conditional on the contents of the cell ?
ie
I have a range of cells A1 to A6 containing the results from the last F1 race :
Schumacher
Montoya
Raikkonen
Irvine
Webber
Salo
can I make the comment background pic *conditional* on what's in the cell so it shows a pic of Montoya or Salo or even Jensen Button if he ever makes it into the finishing 6.....
I suspect it's a VBA solution
thanks
Chris
marker schumacher
This message was edited by Chris Davison on 2002-05-19 11:51
I know how to put a pic as a comment background (ie family photo, or a landscape etc etc when the mouse hovvers over the cell)
is it possible to make it conditional on the contents of the cell ?
ie
I have a range of cells A1 to A6 containing the results from the last F1 race :
Schumacher
Montoya
Raikkonen
Irvine
Webber
Salo
can I make the comment background pic *conditional* on what's in the cell so it shows a pic of Montoya or Salo or even Jensen Button if he ever makes it into the finishing 6.....
I suspect it's a VBA solution
thanks
Chris
marker schumacher
This message was edited by Chris Davison on 2002-05-19 11:51