title: Change cell value based on cell color in google spreadsheet
body: <p>I've been searching for a way to change a cell value (e.g. "Text" if cell color is red) based on another cell color?</p>
  
  <p>Is there a way to do this?</p>
  
  <p>I know there's a way to change a cell color based on cell value, but I want the opposite way,</p>
  
  <p>anyone have idea? be it a script or formula</p>