Format text color

  • Thread starter Thread starter John
  • Start date Start date
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!
 
Format | conditional format.

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



"John" escreveu:
 
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.
 
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:
 
Back
Top