title: (Excel) Conditional Formatting based on Adjacent Cell Value
body: <p>I'm trying to apply conditional formatting in Excel on a range of cells, based on the adjacent cell's value, to achieve something like this:</p>
  
  <p><img src="https://i.stack.imgur.com/7OSQ9.png" alt="Expense Conditional Formatting"></p>
  
  <p>The goal is to highlight values in Column B (Actual Expense) red if the value is greater than it's adjacent value in column C (Expected Expense). I've followed a number of tutorials that said to apply conditional formatting by selecting <strong>Conditional Formatting>New Rules>Use a Formula to Determine Which Cells to Format</strong> then applying a rule =$B4>$C4 which would format the 'Actual' cell red if it were greater than the 'Expected' cell. This works great for one cell, but not so well when I attempt to apply this to a range of cells. I've used the format painter as well as editing the rule to be applied over a range of cells (i.e. $B$2:$B$5) as shown below but it only bases the formatting on the initial formula (if B4 is greater than C4) and everything undesirably turns red. 
  <img src="https://i.stack.imgur.com/LIbeb.png" alt="enter image description here"></p>
  
  <p>I'd rather not make individual rules for every row. Is there a way to consolidate this into one rule?</p>