Select your range
Conditional Formatting

Formula Is: =ISNA(A1)

format any color you like


"Ken" wrote:

Hi!

Is there any way to use conditional format to make the cell black, when the
formula results of cells are #N/A.

Thank you very much!

Ken