title: Excel conditional for rows according to multiple cell values
body: <p>So I'm looking to get a formula that will set the row to be white/orange/green depending on the amount of cells populated in the row.</p>
  
  <p>each cell with have different data, some text some numerical. It just needs to detect if the cell has been populated/filled with any data.</p>
  
  <p>Example
  A12 + B12 = White</p>
  
  <p>A12 + B12 + C12 + D12 = Orange</p>
  
  <p>A12 + B12 + C12 + D12 + E12 + F12 = Green</p>
  
  <p>Hope this is clear enough.
  Thanks
  DG</p>