Forum Discussion
Question
Hello
How do you empty cells based on a particular value entered in another cell?
Example if cell A1 = NA
Cells A2:D6 are emptied?
Thanks
Thierry
That cannot be done unless writing some VBA code.
Another possibility:
Write on each cell of range A2:D6: =IF($A$1="NA","","Something else here")
