ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   change color of text in cell without conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/104996-change-color-text-cell-without-conditional-formatting.html)

sumGirl

change color of text in cell without conditional formatting
 
Is there a function I can use to change the color of cell contents in
Excel 2003? I do not want to use conditional formatting and I was
thinking there was something like
=COLOR(A1,"RED") but I cannot find any function or command that works
that way. Is this possible?


Marcelo

change color of text in cell without conditional formatting
 
Hi,

take a look at Chip Person Page at

http://www.cpearson.com/excel/whatsnew.htm

There are a lot of tips.

hth
regards from Brazil
Marcelo

"sumGirl" escreveu:

Is there a function I can use to change the color of cell contents in
Excel 2003? I do not want to use conditional formatting and I was
thinking there was something like
=COLOR(A1,"RED") but I cannot find any function or command that works
that way. Is this possible?



bj

change color of text in cell without conditional formatting
 
There is no built in function to do this.
You might possibly do it with visual basic,
but It will probably be complicated depending on exactly what you want to do.

"sumGirl" wrote:

Is there a function I can use to change the color of cell contents in
Excel 2003? I do not want to use conditional formatting and I was
thinking there was something like
=COLOR(A1,"RED") but I cannot find any function or command that works
that way. Is this possible?



sumGirl

change color of text in cell without conditional formatting
 
WOW! Seems like such an obvious feature, I cant believe it! I actually
considered VBA, but just assumed there had to be an easier way.


bj wrote:
There is no built in function to do this.
You might possibly do it with visual basic,
but It will probably be complicated depending on exactly what you want to do.

"sumGirl" wrote:

Is there a function I can use to change the color of cell contents in
Excel 2003? I do not want to use conditional formatting and I was
thinking there was something like
=COLOR(A1,"RED") but I cannot find any function or command that works
that way. Is this possible?





All times are GMT +1. The time now is 08:14 PM.

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