Tick & Crosses In Cells

Hi All,

I'm currently building a spreadsheet to check on our departments IT inventory our staff members are currently using and one of the worksheets I need to have an overview of a particular team and what they have in IT equipment.

But I don't want to see the model numbers or serial numbers of the IT equipment and just want a basic tick to say yes and cross to say no.

I've got as far as using the icon sets via conditional formatting but the some of information I'm referencing isn't in a number format so it's not working completely.

I've had a look online and it appear TEXTJOIN would help but I don't have the most up to date excel version so this option isn't available.

I've attached a version of my spreadsheet with all the formula's and conditional formatting I'm using.

Any help will be greatly appreciated.

Thanks