Forum Discussion
LOOKUP to include formatting with its Return Value? Formatting Code Function? non-VBA request
Without VBA, is it possible for LOOKUP to return formatting of its Return Value? It is much easier if Formatting Code Function (similar to CODE function) can be exposed to end user. I need to di...
Afraid not. Formulae in Excel work with values, not with properties which are applied by formatting.
- Thanks, Is there VBA already done for such?
It'd be complicated. Could you provide an example of what you want to do?
- Thanks for prompt response, instead of duplicating my info, there is later details in my reply to Hans Vogelaar Jul 26 2023 07:55 PM.
Perhaps HansVogelaar could clarify about VBA, that's not my territory.
