Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,047
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting -- copy paste special won't change referenc Ed in Biotech Excel Discussion (Misc queries) 3 July 20th 06 07:54 PM
Deferring conditional formatting? Pheasant Plucker® Excel Discussion (Misc queries) 14 March 17th 06 09:17 PM
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? PaulH_1980 Excel Worksheet Functions 1 March 16th 06 12:51 AM
Conditional Formatting to Test Value in Cell Carroll Excel Worksheet Functions 3 March 9th 06 08:38 PM
enhanced conditional formatting Stuart Excel Discussion (Misc queries) 13 November 13th 05 08:20 PM


All times are GMT +1. The time now is 06:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"