Hi,

the color of the cell depends on the value of the cell or on the event
of change of value?

If the color depends on the value, use conditional formatting.

If the color depends on the change of the value, use Worksheet_Change
event.

Let me know and I will give you more details...

Regards,
Ivan