An Excel Expert to Develop an Excel Spreadsheet for Tracking Student Submissions

Completed Posted 1 month ago Paid on delivery
Completed Paid on delivery

Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated.

I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected.

I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell.

I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thought making a cell in the below row for the date was the only option - any other options to achieve this?

Column A, Row 3 contains Client Name (code), Columns B-K, Row 3 contains the course 14 x units. Column A, Rows, 5 - 19 contains student names. The cells in Columns B-N, Row 5 will include the submission options with a drop down menu or alternatively.

The 5 different grading options are:

Not yet started

Not yet submitted

Submitted for marking

Partially Complete - More work to submit


Each cell and submission option will be selected from a drop down list and needs to have a different fill colour (#b4c6e7, #ffd966, #ffff00, #fff2cc, #92d050). The row directly below the cell will show the date the option was selected and that cell will be the same color of the grade selected.

All cells in the spreadsheet will need to change based on the submission option selected so cell references won't work.

For example, if Not yet submitted is selected in one cell on 16/04/24, that cell will show Not yet submitted with a fill colour of #ffd966 and the row below will show the date 16/04/24 and have a fill colour of #ffd966. Later that day the student will submit and I will need to change the option to Submitted for marking filled with its specific color and the cell in the row below will need to show the date changed and the same colour as the above option.

The spreadsheet must work in Excel 365 and be able to be shared with other users in OneDrive.

I have attached the Excel file I started for your reference. I have also attached a screenshot of the existing file I currently use showing how its used I context, and how manual it is.

Thank you in advance.

Excel Process Automation

Project ID: #38000490

About the project

56 proposals Remote project Active 1 mo ago

Awarded to:


Hello Yes, it can be done in Excel 365. We can utilize VBA (Visual Basic for Applications) to achieve this functionality. VBA can handle events like cell value changes and can execute code accordingly. By using VBA, yo More

$70 AUD in 4 days
(15 Reviews)

56 freelancers are bidding on average $141 for this job


Top 1% in Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More

$180 AUD in 4 days
(531 Reviews)

Hello there, I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bo More

$150 AUD in 3 days
(291 Reviews)

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto More

$40 AUD in 1 day
(241 Reviews)

Hi there, I see that all of your task can be done on Google sheets better giving you the opportunity to have great insights on the data. As long as i am an expert on Excel/ Google sheets of course that i can help on c More

$150 AUD in 2 days
(53 Reviews)

-------------------I CAN DO IT RIGHT AWAY-------------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel d More

$130 AUD in 2 days
(64 Reviews)

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform More

$240 AUD in 3 days
(144 Reviews)

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time More

$250 AUD in 4 days
(49 Reviews)

Hi there Yes, it is possible to create the Excel spreadsheet to track student progress in a course using 5 different options in Excel 365. One way to achieve the requirement is by usin More

$163 AUD in 7 days
(6 Reviews)

Dear Astrid V., I have carefully reviewed your project requirements for developing an Excel spreadsheet to track student submissions in a course. I am confident that I can deliver this project with perfection by utili More

$30 AUD in 1 day
(9 Reviews)

As an Excel-lent expert with a keen eye for detail, I indeed can develop the spreadsheet you need. Working primarily with Excel 365, I can build a system in which each of the five grading options has its unique filled More

$220 AUD in 7 days
(14 Reviews)

"""""""""""""""""""""""""""TOP EXCEL EXPERT"""""""""""""""""""""""""""" Greetings! It can be. I clearly understand what is requirement of the project Excel Spreadsheet for Tracking Student Submissions. I am an EXCEL Ad More

$55 AUD in 1 day
(29 Reviews)

Hi, I have read your project and interested to work with you. I hold master degree in business administration (Finance). Having 5+ years’ experience of Accounts, Finance, Bookkeeping, data entry, excel, word, documents More

$100 AUD in 2 days
(24 Reviews)

As an experienced Excel specialist, I believe I can provide a smart and efficient solution for your need to track student progress using five different grading options. My expertise in Excel extends to the creation of More

$140 AUD in 1 day
(6 Reviews)

As an Excel specialist with extensive experience in creating actionable and intelligent spreadsheets, I'm confident that I can deliver a solution to your submission tracking needs. I understand how crucial it is for yo More

$110 AUD in 1 day
(6 Reviews)

As an Excel aficionado for the past 15 years and a Power BI expert, I believe I'm more than qualified to offer the comprehensive solution you need. I've not only developed numerous spreadsheets in Excel 365 but have al More

$250 AUD in 5 days
(8 Reviews)

Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the w More

$65 AUD in 2 days
(10 Reviews)

Hi there, I am a Data Scientist with excellent knowledge and enthusiasm for Microsoft application development. I can do advanced Excel, Word, Access, Power BI, and Outlook and create VBA macros. Advanced Array Formulas More

$50 AUD in 3 days
(1 Review)

Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?

$55 AUD in 1 day
(4 Reviews)

HI!! I can develop the dynamic solution you need using VBA in Excel 365. I've reviewed your requirements and understand the limitations of conditional formatting. My approach: Setup Dropdowns: Assist with dropdown cr More

$50 AUD in 2 days
(1 Review)

I can do this in few hours, and as a senior developer, I feel, i have enough experience to handle this project. Let's have a discussion , I can start Immediately

$50 AUD in 1 day
(0 Reviews)