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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
conditional format - table - cell empty return default color 1
Cell Background Color Change --> Change Event 5
Change cell color 1
Color cell depending on it's previous value 4
Count cells with content in different color background 2
Copy cell backgound color to another cell 1
Conditional format if difference in cell values greater than 0.50% 1

Back
Top