Hi
this would require VBA (using an event procedure). Would this be
feasible for you?

--
Regards
Frank Kabel
Frankfurt, Germany

"Jo" schrieb im Newsbeitrag
...
Hi

Hope you can help. I want to have a red circle to appear in say A1
when B1
has VH in it. The values in B1 will change and I would want different
colour
circles putting in dependent on the content of cell B1.

Thanks in advance!!