title: How to make cell color change based on value
body: <pre><code>  Dim c As Range
   Application.ScreenUpdating = False
   For Each c In Range("G1", Range("G" &amp; Rows.Count).End(xlUp))
  
  
   If Left(c, 1) = "X" Then c = Mid(c, 2, Len(c) - 1)
   If Left(c, 1) = "L" Then c = Mid(c, 2, Len(c) - 1)
   If Left(c, 1) = "C" Then c = Mid(c, 2, Len(c) - 1)
  
  
  Next c
  Application.ScreenUpdating = True
  </code></pre>
  
  <p>How can I get the cell change the interior color (let's say to light blue) after condition is met? </p>