Not sure if this is better suited for a macro or done via conditional formatting.

Trying to empty a standard template we use and of a certain range I need to empty all cells not containing N/A (typed not error). Anyone care to explain either method will have my thanks for it.