Clear cell contents based on value in another cell

G

Guest

Without using an excel function, how can I clear the
contents in one cell based on a condition being true in
another?
 
B

Bruce Cooley

What do you mean, "clear" ?
1. You could do it manually.
2. You could use VBA:
With ActiveWorkbook.Sheet1
If .Range("A4").Value="whatever" Then .Range("A4").Value="".
End With
3. You could fake it by conditional-formatting the font to white.

Bruce Cooley


: Without using an excel function, how can I clear the
: contents in one cell based on a condition being true in
: another?
 
Top