How to highlight a cell with an error color in Google spreadsheets?

Question

Google Sheets

Which rule to set for conditional formatting of cells containing any error, for example:
#VALUE!
#NAME!
simple text matching doesn't work.

Answer 1

Create a conditional formatting rule. Select "Your Formula" from the "Cell Formatting" drop-down list.
Enter in the formula field:
=or(iserror(A1) , isna(A1))