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.
If I am allowed, I would like to add two quick and simple solutions to the elegant solution from Mr, Mr,mtarler .
1. = IF (A1 = A2, "", "X")
2. = IF (A1 <> A2; ”X”; ””)
3. Insert tick without conditional formatting and VBA:
if you use check boxes from the "Controls Toolbox" toolbar, you can connect them to a cell in the worksheet. After inserting the check box, you are initially in design mode. In this mode you can set the properties of the check box by right-clicking on the box and selecting the "Properties" item in the pop-up menu. If you look at the property "LinkedCell" e.g. Write A1 in, cell A1 is linked to the box, i.e. if the check box is selected, the cell reads "True", otherwise "False". Now you can query the cell in the formulas instead of the check box.
1. = IF (A1 = A2, "", "X")
2. = IF (A1 <> A2; ”X”; ””)
3. Insert tick without conditional formatting and VBA:
if you use check boxes from the "Controls Toolbox" toolbar, you can connect them to a cell in the worksheet. After inserting the check box, you are initially in design mode. In this mode you can set the properties of the check box by right-clicking on the box and selecting the "Properties" item in the pop-up menu. If you look at the property "LinkedCell" e.g. Write A1 in, cell A1 is linked to the box, i.e. if the check box is selected, the cell reads "True", otherwise "False". Now you can query the cell in the formulas instead of the check box.
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)