Creating a duplicate cell and using input to create filled empty cell

New Contributor

I'm pretty new with Excel, and I'm trying to make a homework schedule that I will put into my OneNote Notebook to help keep organized for my classes. I've run into a problem though, I am trying to create a duplicate conditional format to make the dates light up for the due date of the assignment, but since I have more than one class to light up one date, I thought I would make empty cells that would represent the date and color of the class to let me know which is due when, and if I have more than one assignment due on a certain day. Is there a way I can do this using Formulas and Functions? Help would be appreciated, Thanks!

1 Reply