Checklist

Hi,

i have been working on my checklist for a while now and since im not terribly good at excel i was wondering someone here could take the time to look at it and let me know if its good or what i can do to make it
better?

heres is the general idea of the checklist.

worksheet LCI-1 has ca 50 checkitems and all items have 3 checkboxes, only 2 of these checkboxes are gonna trigger TRUE/FALSE statements in the Data validation sheet.
The data validation sheet will sum up all true statements and this sum will later be used to trigger one of the red filled checkitems to green.

So, in order to fulfill conditions for the first red filled checkitem on LCI-1 worksheet all the items starting with * symbol must be evaluated as completed/NA.

Am i making it more complex then it needs to be?

Is there a fundemental flaw in this checklist im missing?

list is attached , LCI-1/data validation sheet is only ones i need checked

Appriciate any help i can get-


regards

Thanks for your responce !

yea, i guess using X would go also but as you mentioned it does look better with the checkboxes imo.
gonna go through the checklist again to see what formula is incorrect.

thanks again