Forum Discussion
Solved
Does anyone know how to: Cell A1 = Cell A2, enter (checkmark) in Cell A3?
And if not equal, enter an "X"? I tried inserting symbols and wingdings in an IF statement, and could not get them to work. Only normal text would work. Please help.
There is another technique that works. Building on SergeiBaklan 's solution. one could simply use the formula
=N(A1=B1)
[which gives 0 or 1] in combination with the number format
✔;✔;✖
or even
[Blue]✔;✔;[Red]✖
if you want to get fancy!