Forum Discussion
VLOOKUP
How to make VLOOKUP returning not only the value in the cell but also the colour. It does not work always. Any suggestion what should I do?
If the cell containing the return value is coloured by conditional formatting, you could apply the same conditional formatting rule(s) to the cell with the formula.
If the cell containing the return value was coloured manually, it would be complicated - formulas return only a value, not formatting.