Tick Box Equations

[vglenn93]

So Im having issues with filling in the formula for my tick box. I have an entire column with tick boxes which can be individually checked off. However I was wondering if there was a faster and easier way to format the cells to there own cell three columns down without having to individually format each check box as I have a table with over 500 rows (its for expense tracking by item for a mechanic shop). Hope someone can help me

Thanks

Veronica

 

[Jeffrey Mahoney]

Welcome to the board Veronica,

What is a tick box? Have you ever used a symbol in a cell as a checkbox? Wingdings2 Capital P looks like a checkmark. Wingdings2 Capital R looks like a checkmark in a box. You can use it in a formula to test other cells. You can copy the checkmark easily to other cells in the same column. Format your cell font as Wingdings2 and the letter P in it.