Can we extract data identified by the new Conditional Formatting?
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
"Quco" wrote:
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?
|