This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Word macro: how to apply highlight to *all* selected text
Thread poster: Samuel Murray
Samuel Murray Netherlands Local time: 00:01 Member (2006) English to Afrikaans + ...
Dec 24, 2019
Hello everyone
I have a table in which I want to highlight certain cells. I'm using Ctrl+select to select the cells that I want to be highlighted. If I select cells and then use the normal "Highlight" button or function, it highlights all selected cells. But if I use the following macro, it highlights only the cells that I have selected last:
Sub highlight_with_shortcut() Selection.Range.HighlightColorIndex = wdPink End Sub
I have a table in which I want to highlight certain cells. I'm using Ctrl+select to select the cells that I want to be highlighted. If I select cells and then use the normal "Highlight" button or function, it highlights all selected cells. But if I use the following macro, it highlights only the cells that I have selected last:
Sub highlight_with_shortcut() Selection.Range.HighlightColorIndex = wdPink End Sub
Just to be clear, the cells that I want to highlight are not next to each other, so I'm holding in Ctrl while selecting additional cells. The macro above then applies to only the cell(s) that I selected last, but I want the macro to apply to all selected cells.
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.