is at hand a fomula that will *automatically* sort a cell by environment colour?
for example. if you chose red it go to the top. ashen, it go underneath red and green, underneath pale.
Cheers.
Paul
Answers: You in actual fact want to sort blank cell next to conditions colors? It's markedly much possible.
http://www.ozgrid.com/VBA/Sort.htm
Just affix second code to it to sort the result column.
Good luck. :)
You could enjoy a covered column that you could use as the sort criteria - i.e. Red = 1, blue = 2, pale = 3, etc. Pull your sort bad the unobserved column. This is the singular instrument that I know to gross that work.