Format text color

J

John

I have a formula in a cell...if(A14<A15,"Missed","Made) & "FSP"

How do I get the text color of Missed to be red, Made to be blue and keep
the text FSP black?

Thank you for your help!
 
M

Marcelo

Format | conditional format.

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"John" escreveu:
 
R

Rick Rothstein

You cannot have different parts of a cell's value formatted differently from
each other when that value is the result of a formula. There may be a VB
solution to this, but you would lose the formula and have to let VB handle
the testing and the placing of values into the cells (you would need to
provide a little more information for a VB solution though; such as, start
row for your data, column where the "Missed/Made"&"FSP" are supposed to go)
and this would require that macros be enabled.
 
M

Marcelo

sorry I did not understand your question on the first time I read it,
conditional format will not works.


--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Marcelo" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to extract separated text by many commas in Excel? 0
Color coding cells 2
Change different cell based on conditional statement 4
How to type each letter of the alphabet automatically in a specific color in Word? 0
conditional Formatting cell wildcard 3
Last Row used in calculation 4
Need Help Inserting Text Word 2003 3
Conditional format cell containing hyperlink 2

Top