Forum Discussion
Formula to add a symbol to a cell
I'm fairly new to formulas. I'm wondering if it's possible to create a formula that insert a "tick" symbol and auto fills the cell with a colour, or adds a "X" and fills with a different colour, depending on whether "yes" or "no" is entered into the cell.
1 Reply
Hi Wendy,
You can change the colour of the cell based on its value by using Conditional Formatting!
But adding something to the cell value in place as the cell value is yes or no. this is not possible, except by using some other solutions!
But it's possible in another cell.
Please find the attached file to see the possible solution.
