Delete contents of cells

  • Thread starter Thread starter mikespeck
  • Start date Start date
M

mikespeck

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data from a cell to another workbook if certain criteria 14
Leave final cell blank 2
Conditional formatting referencing multiple cells. 2
Cell Range Split into Multiple Cells 3
Timesheet formula problem 2
Conditional Proctection? 1
Using two Vlookup in one Cell 1
Need cells to show as zero or empty 3

Back
Top