title: How do I find the color of the cell which has been conditionally formatted
body: <p>I want to give a message box "Please resolve errors" if any cell in the range ("H1:H100") has fill color RGB = (255,179,181).</p>
  
  <p>But the trick is that the cell in this range has this RGB on some conditional formatting condition. By default it has a different RGB.</p>
  
  <p>Tried using</p>
  
  <pre><code>for i=1 to 100
      if Cells(i, 8).Interior.Color = RGB(255, 179, 181) then
          msgbox "resolve errors"
      end if
  next i
  </code></pre>
  
  <p>Even if the cell color is RGB(255,179,181) it is not going inside the loop because this RGB is on conditional formatting.</p>