Conditional formatting for error values


I'm using VLOOKUP for status information from another table. The referenced table sometimes does not have the requested row, so I get back the #NO MATCH error. This does not looks nice, so I was trying to hide from the users and set conditional formatting - if column value equals to #NO MATCH set the font foreground color to white -> the error will be there, but invisible.

It looks like this does not work -the error messages are not possible to format?

Best Answer