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")