Conditional formatting not working in a cell with a colomn formula
Hi - I have a colomn that has a vlookup formula and I want it to be blank if there is #NO MATCH. I used conditional formatting to make the background white and the text white - but it is not working.
Here is the formula:
And here is the conditional formatting:
Any ideas if this can be fixed?