Vlookup/conditional formatting

[david_pt]

So here's the problem:

I used a VLOOKUP function in a cell. The returned value is.... "zero", because the returned value was none since that cell was blank.

Now, I have a "0" on that cell. No matter if I hide it through excel preferences, or whatever, even if I try to FORMAT it's background color accordingly it will not be right. And here is the reason:

I want two conditions to be met, one is the cell is "0" or the returned value is blank: I want that background to be white. The second one is if returns any value/word at all: I want that background to be grey

No matter what I try, the cell with the "supposed vlookup value of zero" will always be grey, and not white. Must be due to some sort of conflict with vlookup, assuming it always does return a value, but even if I try a white background if the value is zero, it still doesn't work.

[shg]

Set the default formatting to white, and use conditional formatting to make it grey if the cell value is non-zero.

[david_pt]

Worked, it was pretty simple actually...

Thanks