View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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