| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete contents of cells
I need some help. If Cell A4 has a value of 0 I need the contents of A4 B4 C4 D4 E4 and F4 to be deleted. Can anyone help? -- mikespeck ------------------------------------------------------------------------ mikespeck's Profile: http://www.excelforum.com/member.php...o&userid=34946 View this thread: http://www.excelforum.com/showthread...hreadid=565550 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Delete contents of cells
Do you need them DELETED or just blanked out with a formula?
"mikespeck" wrote: I need some help. If Cell A4 has a value of 0 I need the contents of A4 B4 C4 D4 E4 and F4 to be deleted. Can anyone help? -- mikespeck ------------------------------------------------------------------------ mikespeck's Profile: http://www.excelforum.com/member.php...o&userid=34946 View this thread: http://www.excelforum.com/showthread...hreadid=565550 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Delete contents of cells
Justblanked out, sorry! -- mikespeck ------------------------------------------------------------------------ mikespeck's Profile: http://www.excelforum.com/member.php...o&userid=34946 View this thread: http://www.excelforum.com/showthread...hreadid=565550 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Delete contents of cells
1. If you have a formula in those cells you can change it to look like this
=IF(A4=0,"",formula) this will make the cell look empty, and make it's value equal to nothing. 2. If you have entered values in the cells you can use conditional formatting and select "formula is" with the following formula =$A$4=0 click the "format" button and change the font color to white (or whatever you cell color is). Then click ok. This will make the cells look empty but keep there value the same. 3. You could write a macro that would actually delete the cells every time you enter 0 in A4. I can't help you here, but I know it's possible. "mikespeck" wrote: I need some help. If Cell A4 has a value of 0 I need the contents of A4 B4 C4 D4 E4 and F4 to be deleted. Can anyone help? -- mikespeck ------------------------------------------------------------------------ mikespeck's Profile: http://www.excelforum.com/member.php...o&userid=34946 View this thread: http://www.excelforum.com/showthread...hreadid=565550 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Swap contents of two cells | Excel Discussion (Misc queries) | |||
| how to delete contents of cells having specific data | Excel Discussion (Misc queries) | |||
| Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
| Delete contents of unprotected cells in workbook | Excel Worksheet Functions | |||
Hybrid Mode
