Clear cell contents based on value in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Without using an excel function, how can I clear the
contents in one cell based on a condition being true in
another?
 
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?
 
Back
Top