That's was I was getting at in Post 4. If it's text that looks like a number, you need to make excel think its a number. You can do that, for example< by adding 0 to the output of the VLOOKUP (changing it in G39 from text to number). The VALUE function does the same, but in the conditional formatting equation. Different route to the same result.