View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Grosz Steve Grosz is offline
external usenet poster
 
Posts: 3
Default How to accomplish?

Ok here's my situation. I'm not much of a VB programmer, but wanted to try
something.

We generate a worksheet once a week that has 4 columns.

Col1 - name
Col2 - last weeks position (a number value)
Col3 - this weeks position (a number value)
Col4 - size

I would like to compare col 2 & 3, and if col1 is larger, display a image,
if col2 is large, display a different image in a cell on the same sheet.

How can I accomplish this? Loop through all the users, compare the values
of col2 & 3 for each of them and display a image in a seperate cell, say
col 5??

Any help on this would be greatly appreciated!!!!

Thanks!
Steve