Assignments – Hearts Out!!

As, I have mentioned in my Previous blog, I am continuing with How I used conditional formatting for the assignment Enactus Scoring Model.

I ensured that Scores are in drop down box, So that the person can choose from the set of predefined values, instead of random values.

Based on the inputs score will be calculated based on the scoring rubric. So that if scoring rubric is changed, the table will be changed automatically. And you can see that conditional formatting is applied for each cell.

Weightage points is based on the criteria and their weights sheet. And conditional formatting is applied to that table also.

Based on the sum of all weightage, the projects are ranked. And the first 4 ranks are selected.

And at last comes my favourite part of the assignment. The Dashboard…

This dashboard ensures that everyone can know about the details about individual project. By using conditional formatting, it helps to know for much it excelled in each criteria.

Happy Conditional Formatting!!!

I would like to mention some instances where I have used the conditional formatting while doing my assignments.

Creating a Course Calendar

Here I have used conditional Formatting to have different colours for my assignment Status. It will be in green if the assignment is completed. It will be in light red if the assignment is nearing the due date.

Creating a database to select the best Car for buying second hand:

In this green colour is filled for boxes which gives the top 10 profit%. Red is filled in boxes which should be completely avoided next time. Meanwhile red coloured boxes are used to denote the cars which should be bought with some amount of concern.

Project Selection Scoring Models

And for the next assignment Project Selection Scoring Models, even more conditional formatting will be used. And yes Gifs will be uploaded for that too..

So Stay Tuned for further Updates!

Category: Assignments

Conditional Formatting in Enactus Scoring Model

Conditional Formatting & Project Managers!