title: Excel VBA Select Cells based on Conditional Formatting applied
body: <p>I am watching lots of videos explaining the code for selecting cells but I cannot figure out how to accomplish the following. Anyone able to provide assistance?</p>
  
  <p>To select all the cells in Column A that have conditional formatting applied to them. There will be cells that are colored red and also cells that are not. They will be sorted by cell color with the red at the top. I only want to copy the red "rows" over to a new worksheet. </p>
  
  <p>I need to copy the entire row(s) each time but the number of conditionally formatted rows will change from worksheet to worksheet so I need some kind of loop I think that will stop at the first row that is not red.</p>
  
  <p>Peace and respect,</p>