title: Find consecutive uppercase letters in Excel column
body: <p>I would like some help with highlighting the cells from a column that have consecutive uppercase letters (2 or more); Many times I see typos and it is very time consuming to manually verify every row.</p>
  
  <p>The column can have values like:</p>
  
  <p>"CEar downing sun"</p>
  
  <p>"Main tWO street"</p>
  
  <p>"Yesterday"</p>
  
  <p>"Today will be bETTer"</p>
  
  <p>In these cases I would like the formula to highlight row 1, 2 and 4. I tried with Visual Basic but I am not too good at it.</p>
  
  <p>I appreciate any help I can get on this.</p>