New_2_Excel
New member
- Joined
- Nov 19, 2017
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi, I'm a school teacher and I head up an ISR Department and I am attempting to do a Spreadsheet that keeps track of several things, such as; Student Name, Time Served In Detention, Infraction, etc... I should state that my wife found a generic spreadsheet that "she" was able to change things around a little bit to fit what I was looking for... BUT here's my question:
At the top of the sheet, I am wanting to have different categories such as; T Tardy, LD Lunch Detention, SKC Skipping Class, etc. I want to assign each infraction its own color, and be able to type in the abbreviation in the cell area, and once I type in the abbreviation of the infraction, the color will automatically pop up in the cell area so I can get a good visual on what's going on. PLEASE HELP!!!!
Attached is a sample of what I want to know how to do; Change the infraction categories, assign each categorie its own color and abbreviation that corresponds with it; so once I type in the Abbreviation in the cell, it will automatically change to that color. If you could do screenshots that would be awesome! If not, just clearly explain. Thanks!
At the top of the sheet, I am wanting to have different categories such as; T Tardy, LD Lunch Detention, SKC Skipping Class, etc. I want to assign each infraction its own color, and be able to type in the abbreviation in the cell area, and once I type in the abbreviation of the infraction, the color will automatically pop up in the cell area so I can get a good visual on what's going on. PLEASE HELP!!!!
Attached is a sample of what I want to know how to do; Change the infraction categories, assign each categorie its own color and abbreviation that corresponds with it; so once I type in the Abbreviation in the cell, it will automatically change to that color. If you could do screenshots that would be awesome! If not, just clearly explain. Thanks!
Last edited: