remove colored rows
Do you want to actually Delete the rows with colored cells, or do you just
want to remove the coloring from those rows but leave the data in them?
To just remove color and leave the information, choose the columns and use
Format | Cells and go to the [Patterns] tab (Excel 2003) and choose No Color.
If you want to actually delete the rows and data, it would help to know
which two columns we are talking about. Also, you mentioned "( colored cells
in first and second column is equal)" -- does this mean that the row should
be deleted ONLY when the cells on a row in those two columns are same
not-white color?
"climate" wrote:
Hi
I have 2 columns that many of it's rows has colored ( colored cells in
first and second column is equal) , i want to remove colored rows.
Would you please help me?
regards
climate
|