Text Highlight Color in Excel as in Word
When a text with a background Highlight Color is copied from Word to Excel the text highlight color behind the character(s) is removed. You could expand in the Excel ribbon with a text highlight color button, which becomes active when a text is edited in a cell.
I'm trying to convince my manager to use excel instead of word with a table to automate the daily report but I cannot highlight the text in question in exel
The Highlight Color can be used in a cell to automate with for example with a macro to check misplaced/corrupt digits/characters/brackets/points and commas in numbers etc. So that large Excel files can be checked fast on errors by automation.
Drawing manually using an inking pen on an Excel sheet is old fashion and too slow. If there is a button for the Text Highlight Color it can be recorded and activated with a VBA macro. One can also use the CELL infotype function to analyse highlighted texts easily then when it's inked with pen on the sheet, because the CELL function doesn't support the INK tools.
In Excel 2013 there is a feature called Inking where you can somewhat highlight text in a cell. This feature includes a pen, highlighter and an eraser with a limited selection of colors to choose from.
Go to the REVIEW tab, the last group is Ink. Click on the Start Inking icon and a new INK TOOLS section appears with a PENS tab.
Requires a somewhat steady hand but as an alternative it works pretty good. I hope it helps.