Can we extract data identified by the new Conditional Formatting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can we extract data identified by the new Conditional Formatting function? I
think this new tool is really helpful, but for large sets of data I have been
asked to isolate thos values in a separate Worksheet which is making my work
kind of difficult. Is there any way to isolate the values I have highlighted
with the Conditional Formatting and thgen copy & paste to a new worksheet?
 
If you're talking about excel 2003, then no. In Excel 2007, you can sort a
column by the cell's color, whether that color is from formatting or
conditional formatting.
Bob Umlas
Excel MVP
 
Thank you Bob. I am using 2007, and sorting the worksheet using the Custom
option works pretty well. I was able to sort by "cell color" and I choose to
move those cells to the top of the listing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

script or format to identify duplicate data 2
Conditional Formatting 6
Extracting specific rows out of one worksheet based on an identifi 1
Conditional Format - How to View??? 1
Conditional formatting overwritten with copy 3
Conditional formatting only working for half of worksheet 1
Conditional Formating - by row, not by column (Office 2007) 1
Pasting into a cell with conditional formatting 1

Back
Top