highlight column cells red when there is a 0

[hp801]

I have a file that has a column of data that pulls a quantity on hand using a vlookup and I want to highlight the cells that return a 0 by filling the cell with a color like red.
Is there an easy VBA code to do this or is there another way to do this without having to add columns?

Any help with this would be appreciated.

[Special-K]

Try Condtional Formatting

Select the entire range you want to highlight, (e.g. A1:A100)

Conditional Formatting
New Rule
Use a formula to determine...

=(A1=0)

Format as required

[hp801]

Is there a trick to getting conditional formatting to work in cells that already have a formula?

[Special-K]

You can have more than one conditional format in a cell.
What conditional formatting exists in the cells at the moment?

[hp801]

I have a vlookup in the column that I would like to use the conditional formatting.

[Special-K]

You need to explain clearly what you're trying to do.

You asked to highlight a cell when it is zero.
I have given you the solution on how to do that.

It doesn't matter if the cell contains a value or a formula.
Condtional formatting looks at the cell value (whether its a value entered directly from the keyboard or its the result of a formula).
You don't need to put a VLOOKUP in the conditional formatting, just checking the result of the cell that contains the VLOOKUP is enough (and probably quicker).

If you're still stuck post the file with a CLEAR description of what you're trying to achieve, ie what the VLOOKUP formula is (as I dont fancy spending all day guessing).

[hp801]

Here is an example of what I am trying to do. Column D of Master sheet is where I would like to have the "0" highlighted and it is also doing a vlookup?
I left the conditional formatting that I tried in column D so you can see what I am doing wrong.
Thank you for you patience, I look forward to the solution that you share.

[Special-K]

1. Change the formula in D2 to

=IFERROR(VLOOKUP(B2,'Daily reload file'!B:E,3,0),0)

0 is a number, "0" is text - the condtional formatting formula is checking for 0 as a number not text

Copy the formula from D2 down to D23.

2. Select D2:D23
Conditional Formatting
New Rule
Use a formula to determine...

=(D2=0)

format as green

[hp801]

Amazing, I am just starting to learn how to use excel/vba and really appreciate support from masters like yourself!!

Thank you!!