 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008delete color cells
Hello Dear experts 1) I have 2 columns (A1:B1000), many of them are colored(red). i want to delete digit in these colored cells. 2) In above coloumns, i want to delete many of cells with 0.06 (not colored). thank's and regards See http://www.rondebruin.nl/easyfilter.htm  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hello Dear experts > 1) I have 2 columns (A1:B1000), many of them are colored(red). i want to > delete digit in these colored cells. > 2) In above coloumns, i want to delete many of cells with 0.06 (not > colored). > thank's and regards Thank you Bob this program is very well for delete rows but i want to delete color cells without remove related rows, Again,thank's for your guidance regards > See http://www.rondebruin.nl/easyfilter.htm > [quoted text clipped - 4 lines] > > colored). > > thank's and regards Do you mean just move the cells alongside to take their place? If so, do you want to bring the next column or next row into place? Are the cells just colour filled, or conditionally formatted? Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Thank you Bob > this program is very well for delete rows but i want to delete color cells [quoted text clipped - 11 lines] >> > colored). >> > thank's and regards Hi Bob 1- no , 2- no , 3- yes . i want to delete digits in color cells only, without delete of rows and columns. best regards > Do you mean just move the cells alongside to take their place? If so, do you > want to bring the next column or next row into place? [quoted text clipped - 16 lines] > >> > colored). > >> > thank's and regards
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.