Is this possible?

A

A_Record

Hi, I've used Excel basically for years but i'm now trying to d
something that my self teachings can't handle.

I've created a returns database for the company I work for. I hav
conditionally formatted a column so that If the return has been carrie
out the word "YES" turns the cell green and if it hasn't, the word "NO
will turn the cell red.

Is it possible to set up something so that all the cells saying "NO" an
have turned red will be copied into a another spreadsheet so that i hav
a tab which contains only the uncomplete returns?

Please help

Many Thank
 

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

Change the colour of a neighbouring cell 6
Is this possible? 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Excel does not accept text format! 0
Program buttons to create a word document 0
Cumulative formula for word table 0
Merging from an Excel file with graphics 1
Create a chart from a table in word thats dynamic 0

Top