title: Conditional format based on a cell's color
body: <p>I have a column with conditional formatting rules set to make the background one of three colors based on how close the date is in comparison to the current date (Today's date + 7, + 15, +30 days). </p>
  
  <p>I want to extended the conditional format across to effect the entire row, rather than just the individual cell  for the user more easily to see which item's date is approaching.  </p>
  
  <p>Is it possible to do a conditional format using a cell's format?</p>
  
  <p>Update: To explain it further. Conditional format is set to a column: if a cell value is in between today's date and 7 days from today's date, it is formatted to have a green background. I want this format to extend across the ROW in which the value turns green.</p>