Z
Zorian
I have a cell which has plain text i.e. "Hello World" but between
Hello and World I press Alt-Enter to place the word "World" on the
second line so that the column width doesn't have to be long. But
when I reference this cell from another one, Excel not only shows a
weird ASCII character in between the words but also does not show the
two words on separate lines as in the original cell. Is thre a way
around this? TRIM and CLEAN did not do anything.
Also, I have a function that compares two cells =IF(A1=A2,"YES","NO")
and I would like to do a conditional formatting so that a YES will be
in Blue color and a NO will be in Red. How is this done? I tried
something that we discussed previously i.e. [Red][...condition] but it
only seems to work for numbers.
Any help would be highly appreciated !
Thank you,
Zorian
Hello and World I press Alt-Enter to place the word "World" on the
second line so that the column width doesn't have to be long. But
when I reference this cell from another one, Excel not only shows a
weird ASCII character in between the words but also does not show the
two words on separate lines as in the original cell. Is thre a way
around this? TRIM and CLEAN did not do anything.
Also, I have a function that compares two cells =IF(A1=A2,"YES","NO")
and I would like to do a conditional formatting so that a YES will be
in Blue color and a NO will be in Red. How is this done? I tried
something that we discussed previously i.e. [Red][...condition] but it
only seems to work for numbers.
Any help would be highly appreciated !
Thank you,
Zorian