Text color in Excel

[vvlad]

Is there a way to change the text color with a formula/function?

If I write
=(3+2)
the cell will display 5.

Is there such thing like
=colour(blue)?

Thanks.

vlad

 

[xlbo]

nope - best bet is to look into conditional formatting.

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[dhulbert]

You could write a VBA function that combined the formula you want in the cell with a line to change the colour of the text in the cell


I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[vvlad]

Thanks for answering, I was afraid of that.

I can not use conditional formatting nor VBA as I export a text file to Excel. I wanted to have some lines automatically formated when a user opens the new file in Excel.


vlad

 

[shetlandbob]

Get them to open it using your own macro, which can be built in to everyones excel using an add-in. Then when the file is opened you can do formatting on it.



Robert Cumming

http://www.consultantengineer.co.uk