Forum Discussion
Solved
Special characters added to a cell based on a condtion
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...
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!
- Awesome, Riny_van_Eekelen! Many thanks... that worked perfectly and exactly how I wanted it to!