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

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