selecting all cells that have cond. format. applied

[xtreme07]

hi,

i have a list of 200k rows, from which about 100k meet the cond. format. rules and therefore the 100k are highlited in red.

i would need a way to copy-paste these 100k cells to another file. wondering if there's a semi/automated way to do this.

 

[kpark91]

You could look for only the red-highlighted cells and then copy and paste?

 

[MrKowz]

VBA can't look for conditionally highlighted cells without some really elaborate coding. I would recommend having VBA find these cells based on the exact condition that makes them red.

What is the condition/formula that returns a red cell? Do you want to copy entire rows or just individual cells?

 

[RoryA]

Which version of Excel? In 2010 VBA can use the displayed format, whereas in 2007 it can't.

 

[xtreme07]

ty for your replies.

i have managed to do this on a semi-automated basis.
i chose filter by > color (i chose red)
then, only the cells with red where displayed. this allowed me to select with a click of the mouse all these colored cells and then copy-paste to another file.

Note! to select with a click of the mouse all the cells in the table, one should locate the mouse pointer half the way from A0 to A1 (between A0 and A1), until you can see a black arrow pointing down. that's when the click is made and all the cells in the table are selected. hope it makes sense as i can't find a better way atm to explain it