Make Excel Display Ticks And Crosses

One of Excel’s less-recognised features is the ability to convert simple numbers into icons using conditional formatting. The most useful application? Converting a list of Yes/No possibilities into ticks and crosses.

Office expert Helen Bradley runs through the use of the Conditional Formatting feature. If you select a column of numbers featuring 0 for no, 1 for yes (and numbers in between for an exclamation mark), it can easily be turned into ticks and crosses by choosing that option from the Conditional Formatting Icon Sets. It’s easy to access the basic option from the Home tab, but it’s less obvious how you stop the number itself displaying in the column as well. To do that, select Manage Rules –> Edit Rules under Conditional Formatting and make sure ‘Show Icon Only’ is ticked.

It’s a handy feature and one I often take advantage of (I have a large spreadsheet that tracks my flights and identifies whether I’m going to maintain my frequent flyer status each month, for instance). Hit the post for full details on how to use it.

Recording Yes, No, Maybe so in Excel [Helen Bradley]

The Cheapest NBN 50 Plans

Here are the cheapest plans available for Australia’s most popular NBN speed tier.

At Lifehacker, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.


3 responses to “Make Excel Display Ticks And Crosses”

Leave a Reply