copy rows based on celll colour

[dileepkmr3]

i hav rows having having few cells with different colour. i need to copy only rows which cell contains red color only and ignores if the same row contains other colour cells...those copied rows need to be shifted in other sheet

 

[ravishankar]

Under menu DATA, choose FILTER, select range of cells and Sort by color > Custom sort > choose sort by which column > sort by which color >which order and click OK. copy the red rows with red cells.
Ravi shankar