Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon
In a learner's daily attendance sheet, tardiness is marked through triangle shades if a learner is late in the morning or afternoon classes, but if he/she is late in both morning and afternoon the whole box is shaded. A square cell representing the day of classes is divided by a diagonal line creating two triangles. What's the formula to automatically effect the symbols for tardy? If a type "t" left align, the upper triangle (morning) should be shaded, if I type "t" right align, the lower triangle should be shaded, if I type "tt", the whole box should have a full shade. What I am doing is circuitous (after typing "t", I then copy paste the triangle), I know there is a neater and faster way of doing it but I don't know how.
|