ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Two different colors in one sentence (https://www.excelbanter.com/new-users-excel/55978-two-different-colors-one-sentence.html)

Jenn

Two different colors in one sentence
 
I made up this spreadsheet of a phonebook for a co-worker, now he wants to
add what their speed dial numbers are onto this sheet, what i would like to
do, is make it a different color, red for instance. How would I go about
doing that? Thanks in advance

Bill Ridgeway

Two different colors in one sentence
 
Highlight each part of text to be coloured (background or text) and click on
<fill colour or <font colour as required. You can change each cell with
several background and text colours. Fill colour and font colour are the
two blobs of colour usually found on the top right of the screen.

Regards.

Bill Ridgeway
Computer Solutions

"Jenn" wrote in message
...
I made up this spreadsheet of a phonebook for a co-worker, now he wants to
add what their speed dial numbers are onto this sheet, what i would like
to
do, is make it a different color, red for instance. How would I go about
doing that? Thanks in advance




Chip Pearson

Two different colors in one sentence
 
If the cells' values are the result of a formula, you cannot
change the color of one part of the result. However, if these are
just typed in values, highlight the desired part of the value in
the formula bar and choose the desired color.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jenn" wrote in message
...
I made up this spreadsheet of a phonebook for a co-worker, now
he wants to
add what their speed dial numbers are onto this sheet, what i
would like to
do, is make it a different color, red for instance. How would I
go about
doing that? Thanks in advance





All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com