different mark for cell (attendance sheet)

[vlady]

this one is makes it difficult.


the trick is the cell is just divided by border formatting look attachment so the shading part is difficult and also putting up option to do the following

(blank) - Present; (x)- Absent; Tardy (half shaded= Upper for Late Commer, Lower for Cutting Classes)

any suggestion on how to implement... sheet(style of cell, etc. ) is open for revision .

vlad ef.xlsx

[MarvinP]

Hey Vladimir,

I'd write some VBA event macro using Double Click. If the cell is blank then put an X in it. If it is an X the shade top and remove the X. If blank and shaded then make it blank with no shades.

I'd instruct the user to double click in a cell to go through these 4 possible cell types. Should I write the code or do you want a shot at it first?

[vlady]

Good day Marvin,

If you have time for the code I really appreciate it.
My head is twisting in vba specially with multiple options like that.

I could instruct the user ...Actually they are doing it manual as in shading putting x on hard copies.

thanks.

Regards,
Vladimir

[MarvinP]

Hey vlady,

Would you accept a blank for present, T for Tardy, C for Cut and X for Absent? Working with shading is much too hard. Then when you want to count the number of Cuts or Tardys it will be a lot easier...

Much easier... Find the attached where I've done conditional formatting of the shade using the letter in the cell.
I've named a range of cells where the Double Click will happen. See the VBA code behind the worksheet.

Hope this is ok with you.. You can change the CF to different colors or something more appropriate. You could even make the font of the letters a lot smaller so they didn't show.

Double click on any of the day cells and it will rotate through X,T,C,blank.

Hope this works for you...

[vlady]

That's ok and i think much better approach atleast user will not be looking on the legend that its tardy or cut.

thanks.

[MarvinP]

I just posted in the #4 post above. Let me know if you have questions...

[vlady]

....SUPPER NICE!

I will just add another option for say half day absent.I realize the flow know.Just have to ask the users on how many tardy/cut is equivalent of one day absent for the count.

Thanks Marvin this really helped a lot.

Regards,
Vladimir