0

I'm looking for a way to copy a series of cells that have been Conditional Formatted. We have a spreadsheet with cells that we have tagged as "TBD". I created a rule to formate every Row that has "TBD" anywhere in it, which is what we want. Now I'm looking for a way to copy or select everything that we have formatted and have a way to copy it to another document etc.

This is a screenshot of the rule I created:

enter image description here enter image description here

Thanks

Excel 2011, OSX 10.8.2

chrisgruggen
  • 3
  • 1

1 Answers1

0

Use the AutoFilter with criteria *TBD* and copy the filtered cells.

nutsch
  • 5,922
  • 2
  • 20
  • 35
  • Solved it using the same approach... Selected a cell that was coloured and had "TBD" then used the Auto Filter with filter by Color. – chrisgruggen Jan 30 '13 at 23:06