| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| font color | Excel Discussion (Misc queries) | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
| How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
| How can I automatically change the font color of text in cells th. | Excel Discussion (Misc queries) | |||
| How do I change the font color of my sheet tabs? | Excel Discussion (Misc queries) | |||
Hybrid Mode
