How to Automate or Insert a Tick or a Cross Mark on Microsoft Excel

In this tutorial you will be learning about how to automate a tick or a cross mark on Microsoft Excel. We will be using conditional formatting to automate the ticks and crosses. Please follow the tutorial from the beginning till the end and I have shown you step by step process with example on how to automate the ticks and crosses in Microsoft Excel.

#microsoftexcel
#automate
#conditionalformatting
#microsoftexcelshortcuts
#exceltipsandtricks

[hafizsanee]

Hi thank you for your tutorial.. really save my day.. but if i would like to replace the icon that is not listed in the icon selection, is that possible.. i want to use icon from the wingdings text symbol..

[NS-xroo]

Exactly what I was looking for. Very Helpful video 👍

[relyt]

lifesaver!! Perfect tutorial...Thank you :-)

[Mtjbingo]

Excellent and easy to understand..thank you

[naveenkulkarni]

Can we do count tick and cross symbol using countif formula. If we can then please explain

[AnaGuedes-gz]

Some of my columns are giving me a tick even when the value is 0. What can I have done wrong?

[johnmarvesley]

I did all that, worked perfectly, looked great. Then I tried to publish it to my website and all the ticks and crosses reverted to 1 & 0's. Oh well.

[rasheedabari]

This video saved me when my boss asked me to do something similar

[lunadecuba]

Ty for making it soooo easy and simple to understand!

[cookiesncream]

When I close the Excel and then open it back, the symbol is not there anymore eventhough I have saved them prior close Excel. Is there any tips to fix this? thank you