Question

[tmartinez380]

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

[#2]

@tmartinez380 

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