Hi, can anyone help with this checkbox with 3 condition. both "blank","pending","done" is a drop down list selection
IF cell"A2" is "blank" return NIL
IF cell"A2" is "pending" check whether "A4" or "A5" isblank, if isblank return "pending" else return "check"
IF cell"A2" is "done" check
