title: Google Spreadsheet conditional formatting script
body: <p>I am trying to figure out how to use conditional formatting on a google spreadsheet similar to what you can do in excel via a formula.</p>
  
  <p>I want cell A2 to change to Green if cell O2 has a value of "X" and this will be done on both columns all the way down.  I know this will require a script.</p>
  
  <p>I ran across a link that is similar but i do not know how to adjust it to meet my needs.  Is this something that can be done?</p>
  
  <p>Link:  <a href="https://webapps.stackexchange.com/questions/16745/google-spreadsheets-conditional-formatting">https://webapps.stackexchange.com/questions/16745/google-spreadsheets-conditional-formatting</a></p>