Reply to thread

That's fantastic!  That's a really elegant solution.

Unfortunately, I suspect that in spite of your incredible effort to provide as much automation as possible, the OP may not like it because he still has to go through the spreadsheet row by row, make decisions and occasionally hit the delete key.  As he said earlier, suppose there are thousands of lines? Personally, I think the OP needs to give more thought to exactly what he wants, and what effort he is willing to put in, and spell out the requirements in *very* precise terms for us.  This is the only way we'll be able to respond appropriately.

For starters, how are the acceptable colors to be entered / generated?

Tom