SOLVED

Special characters added to a cell based on a condtion

%3CLINGO-SUB%20id%3D%22lingo-sub-2249247%22%20slang%3D%22en-US%22%3ESpecial%20characters%20added%20to%20a%20cell%20based%20on%20a%20condtion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2249247%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20clients%20that%20are%20considered%20active%20until%20they%20pass%20away%2C%20at%20which%20time%20we%20categorize%20them%20as%20deceased.%20Upon%20this%20happening%2C%20I%20would%20like%20a%20special%20character%20to%20be%20added%20onto%20their%20name%20as%20a%20visual%20signal%20to%20let%20me%20know%20they%20are%20'deceased.'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20go%20from%20here%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture001.PNG%22%20style%3D%22width%3A%20245px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F268898i92175B92BDA595E6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture001.PNG%22%20alt%3D%22Capture001.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture002.PNG%22%20style%3D%22width%3A%20242px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F268899iC9328A1DC1954262%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture002.PNG%22%20alt%3D%22Capture002.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20do%20this%20with%20a%20CONCAT%20feature%2C%20but%20it%20would%20be%20easier%20for%20everyone%20else%20touching%20the%20spreadsheet%20if%20all%20they%20had%20to%20do%20is%20select%20the%20client's%20status%2C%20to%20apply%20the%20special%20character%2C%20as%20needed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20conditional%20formatting%20feature%2Fformula%20that%20would%20allow%20me%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3EKristine%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2249247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2249307%22%20slang%3D%22en-US%22%3ERe%3A%20Special%20characters%20added%20to%20a%20cell%20based%20on%20a%20condtion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2249307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1014690%22%20target%3D%22_blank%22%3E%40Kristine2021%3C%2FA%3E%26nbsp%3BCan't%20really%20find%20the%20cross%20symbol%20that%20works%20on%20my%20system%2C%20%26nbsp%3Bbut%20if%20you%20can%20or%20if%20you%20can%20accept%20the%20regular%20plus%20sign%2C%20you%20could%20conditionally%20format%20the%20cell%20with%20a%20custom%20format%20like%26nbsp%3B%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3E%40%22%2B%22%3C%2FSTRONG%3E%3C%2FFONT%3E%20if%20the%20cell%20to%20the%20left%20equals%20%22Deceased%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

 

I have a list of clients that are considered active until they pass away, at which time we categorize them as deceased. Upon this happening, I would like a special character to be added onto their name as a visual signal to let me know they are 'deceased.'

 

I would like to go from here:

Capture001.PNG

 

To:

Capture002.PNG

 

I could do this with a CONCAT feature, but it would be easier for everyone else touching the spreadsheet if all they had to do is select the client's status, to apply the special character, as needed.

 

Is there a conditional formatting feature/formula that would allow me to do this?

 

Thanks in advance,

Kristine

4 Replies

@Kristine2021 Can't really find the cross symbol that works on my system,  but if you can or if you can accept the regular plus sign, you could conditionally format the cell with a custom format like @"+" if the cell to the left equals "Deceased".

Oh! I see what you're saying! I never thought of that... I will give that a try. I've never done any conditional formatting to a cell that's outside the options provided, like something beyond font weight and colour and/or cell fill, sort of thing. I will dig into that more, thanks!
best response confirmed by Kristine2021 (New Contributor)
Solution

@Kristine2021 Attaching an example. Perhaps it helps.

Screenshot 2021-04-01 at 19.28.30.png

 

Awesome, Riny_van_Eekelen! Many thanks... that worked perfectly and exactly how I wanted it to!