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.
dcb12204 this seems like a good use for conditional formatting:
You can create that extra column with some default values (0,1) and then apply the conditional formatting to that column. BTW you can make the font white or background color so the text isn't visible and/or make the column very narrow so that check mark/ X hides the text.