title: Excel: Conditional Format specific cells that match rule
body: <p>Need help with Conditional formatting Rule</p>
  
  <p>In the example below, I only want to highlight the specific cell that passes the rule - E1 > 100% So, only E3 needs to be highlighted in Red. With the current rule, it is highlighting every cell from E4 thru E13. I only want E3 to highlight because E3 passed the criteria. And similarly for other matching E cells.</p>
  
  <p><a href="https://i.stack.imgur.com/8Fi36.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8Fi36.png" alt="enter image description here"></a>
  <a href="https://i.stack.imgur.com/h75Fm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h75Fm.png" alt="enter image description here"></a></p>
  
  <p>I have modified the formula per "UrDearBoy" and this is how it looks now and it works!</p>
  
  <p><a href="https://i.stack.imgur.com/TsLWp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TsLWp.png" alt="enter image description here"></a></p>