Revision timetable - functions to tally the subjects finished and change its colour, etc.

[Kinnow]

Hi, I'm making a revision timetable on excel for my exams coming up, I'd like some functions to optimize my revision scheduling. I've already made the table just need some ways of optimizing it.
This is quite a hefty list of request, completely understand if it's too much to handle

First, I'd like to have a way of keeping track which subjects I've done or not done or doing. For example to turn green if I've finished, turn orange if I'm still revising for it, and red if I can't do it for whatever reason.

Secondly, a separate table that can tally the subjects I've done and the percentage of how much I've done.

Thirdly, function to set a deadline that will evaluate whether I'm behind or not. If I'm ahead, it can tell me how much time I've saved depending on the amount of subjects I have done.

Also if you know any other functions to add that you think will really help in my revision timetable, would greatly appreciate it!

 

[mrshl9898]

Do you have an example table and what you would like to see?

 

[Kinnow]

Do you have an example table and what you would like to see?

Sorry for the late reply. I saw this idea or concept of the timetable I want on social media. Here's a link to it:

What star sign am I? ? #revision #study #dentistry #toothtok #fyp

Here's a picture if you can't access it:

Unfortunately, this example wasn't done on excel but the creator said it can be done but it would be slightly harder. He tried to make a tutorial on how to do it but he was very confusing. You can see in the picture he has a separate box for tallying the completed subjects, then a percentage of how much he's done, and some sort of way of setting a date to evaluate his progress to then give him how many days left he has to complete then and a a counter to tell him the days he's saved( that's optional for me).

Hoped this helped get an idea of the type of timetable I want

 

[mrshl9898]

It's not really helpful for me personally, maybe someone else will jump in.

You said you have a table already, it would be good to see that, along with an example of what you want it to look like.

What you are asking for sounds like some conditional formatting and a few simple formulas. But without seeing what we are working with and want to achieve it's hard to say precisely what you need to do to get that result.