Change Cell Value Based on Another Cell Background Color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top