Poll

Aboot this blog

This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:

feed-icon-28x28.png

DISCLAIMER

Please note that any reviews/recommendations are based solely on my own experience and does not constitute a guarantee that you will have the same experience. Please do your own research before parting with any money - the risk is all yours!

The Briticiser

Looking for my world famous US to GB English spelling converter?

THE “BRITICIZSER”

www.us2uk.eu

IT’S HERE

Tags

  3D Stuff     Bookmarks     Education         Hardware     Windows     Utilities     Software     Excel     Word     Tutorials     Equipment     PHP     VBA     News     Acrobat     Odds and Sods     Plausible Lies     Flatpress     Browsers     Family     Overcoming Disabilities     Bits and Bobs     Reviews  

Find me on Facebook

facebook-icon-28x28.pngVisit my Briticiser Facebook Page to keep up with things here - lots of reviews of stuff I’ve really used and also all kinds of helpful computer tips with a heavy bias towards SAVING YOU TIME.

How to have mixed font colours in Excel comments

Permalink: http://paul.us2uk.eu/?x=entry:entry150513-174658

Cell comments in Excel are a useful way to alert users to information you want them to know about - often to provide them with an explanation about what a particular cell contains, e.g. what it means or how it has been calculated. It’s also sometimes useful to draw the user’s attention to part of your comment by using a different font colour for some of the words or characters.

excel-comment-text-colours In Excel 97-2003 this was simply a case of selecting the text you want to change the colour of and then selecting a new colour from the font colour button the toolbar. Unfortunately later versions of Excel have made it a bit more fiddly to achieve the same effect, though it’s still very easy to do this. Here’s how to do it.

As you can see below as soon as you select the comment (or any text in the comment) the font colour button is greyed out, meaning you can’t use it.

excel-comment-text-colours2

The trick to changing the font colour in this case is to right click either the comment box itself (if you want to change all of the text in the comment to a different colour) or right-click some selected text inside the comment (if you just want to change the colour of that block of text) and then choose “Format Comment…”, and select your preferred colour in the dialogue box which pops up.

excel-comment-text-colours3

This is the dialog box which appears if you right-click the entire cell comment. Note that you will only see the Font tab if you right-click on a block of selected text.

Credit for this tip goes to Microsoft for making life a little less easier than it used to be!

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.

Support our caregiving

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.