help with pairing pictures to certain value.

[executionerhk]

Hi guys, it is me again.

I searched a code, but it didn't work...

Here is what I want to do.
$O:$O is going to be changing according to TODAY()
If the Value is between 7 to 14 days,
it will be a picture locate in G:\\TO-DO LIST\Attention.jpg

If it is value between 0 to 7 days,
it will be a picture locate in G:\\TO-DO LIST\Deadline Urgent.jpg
The picture will be desplay on $A:$A

This will be all I need.

Thanks for they help in advance.

Cheers,
Steve

 

[GlennUK]

How long is the list, and will it be getting longer over time?

 

[executionerhk]

Well it is a todo list. I am thinking just about index plus 100 lines.
It is a to do list. So, when it is done we can remove it.

Thanks Glenn

 

[GlennUK]

You could run a macro to insert pictures .. how are you at VBA? A starting point would be the solutions in this thread :

http://www.mrexcel.com/forum/showthread.php?t=540152&highlight=insert+picture+file

 

[executionerhk]

I am too dumb to get it work.
I just want to use "=if()" to finish it.
I am trying to set up objects. so if it is certain value, call out the objectA
if it is another valie call out the objectB

 

[GlennUK]

How about:

http://www.exceluser.com/solutions/traffic.htm

?