Hi,
I have three conditions that need to be considered, 1) A1="Done"; 2)A1="F/U"; 3) A1 is blank.
I'd like a different symbol for items 1 and 2 (i.e. Check Mark or X or "Happy Face?") and leave cell blank for item 3.
Thank you.
Hi,
I have three conditions that need to be considered, 1) A1="Done"; 2)A1="F/U"; 3) A1 is blank.
I'd like a different symbol for items 1 and 2 (i.e. Check Mark or X or "Happy Face?") and leave cell blank for item 3.
Thank you.
HI DHirsch,
See the attached file and let me know if this this helps...
special character.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Thanks DILIPandey, that's almost got it but, I need a separate symbol if the text is "F/U" (i.e. "!") and a Check Mark if the text is "Done."
Does that make sense and, can you still help me please.
Thank you very much.
Okay.... use below formula then :-
Formula:Please Login or Register to view this content.
Regards,
DILIPandey
<click on below * if this helps>
Yup, that did it!
Thank you so much.
I just love this site and the smart people on it.
Best regards,
DHirsch
you are welcome DHirsch.... cheers
please mark this thread as [SOLVED].. thx
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks