Bjorn,

I will send you an example workbook that uses the workbook's events to
change graphics based on cell content.

HTH,
Bernie
MS Excel MVP

"Bjørn" wrote in message
...
Hi,
Software is Excel 2000.
I have received a problem from an end-user that need to have a flag
displayed in a cell. And this flag should change depending on the content
of another cell.
I.e. I would like the checkered flag to appear in column G, whenever
corresponding cell in column B contain the letter "N". And an american
flag
to appear whenever the cell in column B shows "UK". And if any cell change
from I.e. "N" to "UK", then the corresponding flag should also change.
(Didn't find a Norwegian and English flag :-)
I assume that the only way to do this is with WB programming. Does anyone
know if there exist an easy solution to this problem?
If anyone can help then I could provide a zip file with example.
Thanks for any input.

Brgds

Bjørn Gjerde

KAS IT ServiceDesk