I can't apply conditional formatting on a #No Match cell

pe22 ✭✭✭
edited 12/09/19 in Smartsheet Basics

I'm trying to apply conditional formatting to a column, where I am  using vlookup.

When the vlookup doesn't find the value in the other sheet, it returns a #NO MATCH value in the cell.

This is fine, except when I try to format these #No MATCH cells, it will not take.  

I have the format setup as "If cell equals #NO MATCH (selected from a drop down list), then highlight in green".

What am I missing?