title: Conditional formatting based on neighboring cell
body: <p>I have a correlation matrix, with each correlation represented over two rows of cells - the top cell is the r value, and the bottom cell is the p value.</p>
  
  <p>I want to do conditional formatting of the cell containing the r value, based on the p value that is in the cell below it (basically, I want to colour the correlations according to significance). This doubly complex, in that the conditional formatting has to be different for different rows, as I don't want the p value to be coloured based on the r value that is immediately below it... Is there any simple way to do this without having multiple data tables and cross referencing?</p>