Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 07:55 PM
Kenjiro Yagi
 
Posts: n/a
Default Can Formula Change the Font Color?

I want to make it so if the cell starts with "Failed - .." the font color to
be red and if the cell starts with anything else, I want the font color to
be blue.

Is there a way to do this without running VBA? Thanks!

Kenjiro Yagi


  #2   Report Post  
Old October 28th 04, 07:59 PM
Frank Kabel
 
Posts: n/a
Default

Hi
not possible with a formula but try 'Format - Conditional Format' for
this

--
Regards
Frank Kabel
Frankfurt, Germany

"Kenjiro Yagi" schrieb im Newsbeitrag
...
I want to make it so if the cell starts with "Failed - .." the font

color to
be red and if the cell starts with anything else, I want the font

color to
be blue.

Is there a way to do this without running VBA? Thanks!

Kenjiro Yagi


  #3   Report Post  
Old October 28th 04, 10:34 PM
Ron
 
Posts: n/a
Default

go to Functions, then Conditional Functions
It is fairly self explainitory from there, enjoy.
Ron

"Kenjiro Yagi" wrote:

I want to make it so if the cell starts with "Failed - .." the font color to
be red and if the cell starts with anything else, I want the font color to
be blue.

Is there a way to do this without running VBA? Thanks!

Kenjiro Yagi




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
font color Eagle7 Excel Discussion (Misc queries) 1 January 21st 05 01:20 PM
Cannot change a formula Richard F Excel Discussion (Misc queries) 1 January 18th 05 02:57 AM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 8th 05 12:43 AM
How can I automatically change the font color of text in cells th. les Excel Discussion (Misc queries) 1 January 4th 05 04:06 AM
How do I change the font color of my sheet tabs? DungeonsOfAlcatraz Excel Discussion (Misc queries) 1 January 3rd 05 10:19 PM


All times are GMT +1. The time now is 09:55 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017