Juuljus,

Can u please send me ) an workbook with an example
of oval traffic lights?

I simple need that the oval shapes change their colour (yellow, green, red)
according to a value in cell, do u think u can help me on this?

"Juuljus" wrote:

Nice code Ken, thanks for that.

The problem is, I need do to another advanced filtering on that , and
the lights must go in another sheet into a table. I tried, but it
didn't work. Maybe when done so that all the ovals are separate shapes
it could work.
At the moment I figured out a way with conditional formatting, and it
works. As a deadline is moving, I'm heading forward with another task,
after the project is done, I'll start fine tuning it and then I'll come
back if needed. But as I understand you have personal interest in this
problem, so if you want you can continue working on it.

Again, big thanks to you Ken, and everybody else who participated!

Br,
Juuljus