Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-307469%22%20slang%3D%22en-US%22%3ECreating%20a%20duplicate%20cell%20and%20using%20input%20to%20create%20filled%20empty%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307469%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20pretty%20new%20with%20Excel%2C%20and%20I'm%20trying%20to%20make%20a%20homework%20schedule%20that%20I%20will%20put%20into%20my%20OneNote%20Notebook%20to%20help%20keep%20organized%20for%20my%20classes.%20I've%20run%20into%20a%20problem%20though%2C%20I%20am%20trying%20to%20create%20a%20duplicate%20conditional%20format%20to%20make%20the%20dates%20light%20up%20for%20the%20due%20date%20of%20the%20assignment%2C%20but%20since%20I%20have%20more%20than%20one%20class%20to%20light%20up%20one%20date%2C%20I%20thought%20I%20would%20make%20empty%20cells%20that%20would%20represent%20the%20date%20and%20color%20of%20the%20class%20to%20let%20me%20know%20which%20is%20due%20when%2C%20and%20if%20I%20have%20more%20than%20one%20assignment%20due%20on%20a%20certain%20day.%20Is%20there%20a%20way%20I%20can%20do%20this%20using%20Formulas%20and%20Functions%3F%20Help%20would%20be%20appreciated%2C%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307469%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307470%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20duplicate%20cell%20and%20using%20input%20to%20create%20filled%20empty%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307470%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20the%20actual%20file!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted