title: How to highlight empty/blank cells using VBA macro
body: <p>I realized I messed up asking my very first question, so I will try one last time. I am targeting the same 4 columns from 2 separate sheets that have cells that either contain text or do not. Sheet 1 will be updated automatically, so I will be running this code daily to manually update sheet 2. I am trying to find a way to basically find out which cells are missing the text using a macro. I tried using a code that I found on this website that puts borders on cells containing text and clears borders for empty cells. </p>
  
  <pre><code>Sub BorderForNonEmpty()
  Dim myRange As Range
  Set myRange = Sheet1.Range("C2:C252")
  
  ' Clear Existing Borders
  myRange.Borders.Linestyle = xlLineStyleNone
  
  ' Test Each Cell and Put a Border Around it if it has content
  For Each myCell in myRange
  If myCell.Text &lt;&gt; "" Then
  myCell.BorderAround (xlContinuous)
  End If
  Next
  End Sub
  </code></pre>
  
  <p>This code works, but I want to try to highlight the empty cells with a color opposed to clearing its border. This is also my first time posting on StackOverflow, so I apologize beforehand. Thank you.</p>