Microsoft Office Forums - View Single Post - [Solved] Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon

Marcia · 10-28-2018, 06:30 PM

You assumed correct that:

1. the users overwrite the formulae when and if a pupil is absent, tardy or has skipped classes. The triangles will then be applied in these manual entries.
2. the cells where the formulae remain intact will be in white font.
3. the font must be in black before the user fills up the form so that he/she can determine which cells the combination codes XTI, XTIX, XLE, XLEX, LTI, LLTI, CLE, CTI will apply to.

I have attached a sample sheet of a hard copy of the form after the codes, font sizes and font colors were applied.