Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete color cells
See http://www.rondebruin.nl/easyfilter.htm
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "climate" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete color cells
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 "Bob Phillips" wrote: See http://www.rondebruin.nl/easyfilter.htm -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "climate" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete color cells
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? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "climate" wrote in message ... 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 "Bob Phillips" wrote: See http://www.rondebruin.nl/easyfilter.htm -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "climate" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete color cells
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 "Bob Phillips" wrote: 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? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "climate" wrote in message ... 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 "Bob Phillips" wrote: See http://www.rondebruin.nl/easyfilter.htm -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "climate" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete all cells with color | Excel Worksheet Functions | |||
How do I apply color in cells ..color now shown only in print prev | Excel Worksheet Functions | |||
Use color for delete column or cell icons | Setting up and Configuration of Excel | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |