Formula for Conditional Formatting when VLookup Returns 0

[mcgonma]

I have vlookups that are returning "0" in the cell. I would like to do conditional formatting so that the text will change to be the same as the background color so that 0 all disappear.
What conditional formatting formula would I use for this?

 

[Sufiyan97]

If you have 0 results in column A

you can use

=$A2=0

and then apply font color white or whatever the cells color is.

Another option without conditional formatting is

=IF(VLOOKUP()=0,"",VLOOKUP())