Special characters added to a cell based on a condtion

[Kristine2021]

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:

To:

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

[#2]

@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".

[#3]

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!

[#4 · Accepted solution]

@Kristine2021 Attaching an example. Perhaps it helps.

[#5]

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