title: Find cell with conditional formatting
body: <p>I have conditionally formatted a worksheet to change the color of cells if values are in error. This is for data validation where the user may cut and paste large amounts of data into the worksheet at once.</p>
  
  <p>I want to write a macro (which I will link to a button) to find and go to the first cell with conditional formatting, then the next, etc. So far, no luck. If this is ultimately not possible, I may just remove conditional formatting and have a macro change cell color so that it can be more easily detected with VBA.</p>
  
  <p>I can detect if there is any conditional formatting with</p>
  
  <p>If ActiveCell.DisplayFormat.Interior.Color &lt;> 16777215</p>
  
  <p>but am having trouble putting it into a find sub. </p>
  
  <p>To be more specific, columns A - AF have values and are formatted red if they do not meet conditions. I'd like a duplicate of the find button but for conditional formatting. Does anyone have any suggestions. I've seen similar questions but they seem to be asking for counts or totals and that's not really what I need. Thanks in advance.</p>