Hi J,

If the trigger cell's colour is controlled by conditional
formatting, use the CF formula condition in the second
cell to determine its displayed value.


---
Regards,
Norman


"JAD" wrote in message
...
In response to a change in the background color of a cell, I would like to
enter a value into another cell. While I would prefer to the standard
conditional cell formating feature, I would also use VBA or a function to
solve my problem. Any help would be appreciated. Thank You, JAD