Forum Discussion
Kdube22
Nov 03, 2021Copper Contributor
Replace position abbreviation by initials for Job Title/Initials
Hello, I am needing to create a conditional format in the case that I type an acronym for the job title in one box, it will fill in the initials for the person responsible. For example, I need a...
- Nov 03, 2021
That's not conditional formatting, that's one of lookup (XLOOKUP, INDEX/MATCH, etc). But only if to add initials into another cell. If replace position abbreviation by initials in the same cell that's with VBA programming, not my territory. If so perhaps someone else could help.
SergeiBaklan
Nov 03, 2021Diamond Contributor
That's not conditional formatting, that's one of lookup (XLOOKUP, INDEX/MATCH, etc). But only if to add initials into another cell. If replace position abbreviation by initials in the same cell that's with VBA programming, not my territory. If so perhaps someone else could help.
- Kdube22Nov 03, 2021Copper ContributorThanks for clearing that up!