ExcelBanter - Format text color

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Format text color (https://www.excelbanter.com/excel-worksheet-functions/233331-format-text-color.html)

John

Format text color

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!

Marcelo

Format text color

Format | conditional format.

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

"John" escreveu:

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!

David Biddulph[_2_]

Format text color

No can do.
--
David Biddulph

"John" wrote in message
...
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!

Rick Rothstein

Format text color

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.

--
Rick (MVP - Excel)

"John" wrote in message
...
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!

Marcelo

Format text color

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:

Format | conditional format.

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

"John" escreveu:

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!

All times are GMT +1. The time now is 04:31 AM.