is it possible to see a part of a text in Cell ??

[hurgadion]

Hi,
is it possible to see in a Cell "Good" if in it is "Good Day"... Is it a suitable Text Formatting to do it ??

Best regards,
hurgadion...

 

[Scott T]

You could put "Good Day" in a cell and then format "Day" as white, or whatever color your cell is, so you only see "Good"

in the formula bar highlight "Day" and select the font color from the ribbon.

 

[hurgadion]

OK,
thank You for Answer, I appreciate this... I know this method... but I'm looking for a little more... is a possibility to see in this Cell "Good" + another text ?? instead "Good Day" (value in cell) we see "Good Night" ??

 

[Scott T]

I am not aware of any way to do that. If what is displayed depends on a logical test you could use a if formula to display "Good Day" or "Good Night".