I fully agree with you that it i confusing to make an exception on the representation of cutting classes, always shaded triangle on the right. It is clearly a contradiction on the rest of the coding system but it is the instruction from the higher ups. I suggest we maintain the status quo as is the instruction. Although there is plan to make representations before the approving authorities that we make our own symbol as long as the figures are correct. Could you please make the macro as flexible as possible so that in case the powers that be would approve on our proposal the codes would be easier to amend?
If you must know, the knowledge of the users of this form on the power of Excel to help them in their work is pathetically nil. In fact some of them still use crayons to fill up the form and calculators to get the totals and average daily attendance. I am optimistic that once we present to the powers that be that it is possible to reflect in the form all the conditions in the proper formats of am and pm through the use of different colors and symbols, they will look favorably on such enhanced reports.

How are you going to display cutting classes am, late am, absent pm?

Besides being significantly more convoluted to code for, it'll confuse users trying to get what they want - they'll need the contradictions/exceptions explained, and it'll be more difficult to get the row and column totals correct (If the letters L, X & C in a cell all represent half days (not counting the L in the LE pair), then counting occurrences of these letters makes for simpler and more robust totals formulae.)

The 'authorities', 'powers that be', 'the higher ups', whatever, haven't put the thought into this that you (and I) have; their decisions are often ill-informed and ill-advised, sometimes they're just bloody-minded and want to show who's boss. It's up to you to advise and inform them what's best. At the moment I'm leaning strongly towards my last suggestion of the smaller triangles on top of the larger ones (If you want, we could even keep ALL cutting classes small red triangles, regardless of whether they're sittting atop another larger triangle, to maintain consistency).

I would prefer you to set things in concrete sooner rather than later - I don't want to have to revisit this too often. Remember, I'm doing this for nothing.

I think I might have to back-pedal a little on having something ready at the weekend, something's come up and it's already Friday afternoon here in the UK. Next week's very busy for me too. So you'll need patience, and I'm not giving up and I've made good progress.

Okay, go on with your original codes and symbols for cutting classes like the small red triangles. I will make them see the wisdom of consistency in presenting the am and pm for each case - absent, tardy and cutting classes. You will get perplexed by their formula. Half day absent is .5, whole day absence is 1, while tardy, whether am only, pm only or am and pm is counted as 1. cutting classes has no bearing in the daily total attendance.