PDA

View Full Version : EXCEL 2010



Happy Harry
11-01-2013, 05:07 PM
Hi One and all
I wish to ”Highlight” certain bits of text within a cell.
In WORD 2010 Ribbon, the “HIGHLIGHT function is displayed in the HOME-- FONT section



This same function is not shown in the EXCEL Ribbon


I have Googled without success.
Has anybody discovered a way to do this and if so can you please provide the solution.

Cheers
HH

SP8's
11-01-2013, 05:14 PM
Home ribbon ... look for fill colour. You can highlight with different colours, yellow being the default.

Happy Harry
11-01-2013, 05:25 PM
Thanks SP8 The issue is when I wish to only highlite some of the text/data in the cell, not all of it
i.e the cell contents are "The quick brown fox" I only want to highlight the"brown" word in the text

Cheers


Home ribbon ... look for fill colour. You can highlight with different colours, yellow being the default.

SP8's
11-01-2013, 05:31 PM
The only other possibility that can can think of offhand, would be to change the font colour of the particular word/number and underline/bold it. You can do that in the formula bar ... not in the cell itself.

OR

Try doing the word / number in a 3 different cells and highlight the one you want ... may be a little tricky though.