Excel 2007 : Checkbox auto tick on value

Goodday

I've been reading this forum for quite while now, and I've always managed to solve problems using this forum by just reading things, but now I've got a problem which I can't figure out so I decided to finally register.

I am working on a sheet for internal use in a company. The use of this sheet would be that everyone who uses it in every shift, needs to make their own report. So basically it is just a normal report which has to be sent to the head of the department (me).

But since most of the workers never worked with a computer, or even in Excel, I need to make a few adjustments so that it will be easy for the users who have to write their report.
Now I've come across a problem that I can't solve and I don't know where to start. Since they never worked with Excel and even have trouble of starting a computer, I'd like this to be as easy as possible for them.

My problem is this:
Some workers need to count a cash register and write down how much it contains. I'd like them to write the amount of money in Excel in a certain cell, le'ts say:C15.
In A15 there will be a checkbox (activeX or form?) that automatically ticks itself when a value is entered in C15. But I want it to automatically tick on a numerical value.

And another similiar one will be: In A16 there will also be a checkbox which has to check for a "word value" (Yes or No written in a cell) in cell C16. This is for another task (cleaned up working place). So if they write "Yes" in C16, the checkbox should also be ticked in A16.

I hope I explained this clear enough. If not, just ask and I will do my best to rephrase where needed! Thanks in advance for any helpfull information!

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I would use a formula instead of CheckBoxes & format the cells as Marlett. See the yellow cells in the example. These formulas can replace the checkboxes