title: vba code to search entire workbook for a specific background color
body: <p>I'm currently working on a report project that has subreports and compilation reports all in an excel document. It has 45 sheets in total minus a 'dashboard'-like sheet, a validation checking sheet, and two ghost sheets. </p>
  
  <p>All subreports have its own data validation in certain cells with conditional formatting that will make the cell become red (RGB 192,0,0) if the user puts a wrong data inside it. </p>
  
  <p>The problem that I had is that the sum of 2 wrong data on the same sheet could make the data seems right. But it's not. </p>
  
  <p>The only way I thought that can help me prevent this is to search on all the cells in the workbook if any one of them turned into that red. and I need the code to able to list down the sheets that had the cell(s) into the validation sheet automatically if possible. Thank you in advance.</p>
  
  <h2>Update</h2>
  
  <p>The <a href="https://drive.google.com/file/d/14xAWOjGJGrmknwty2vRCVPixvNkK33md/view" rel="nofollow noreferrer">file</a> I am working on </p>