iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me

TOPIC: Conmparing two cells

Conmparing two cells 7 years 6 months ago #4567


I would like to compare two cells in gradebook, and either give a value or have some sort of conditional formatting. It may be easier if I explain how I achieve this in excel:

My students have a Target grade. Every time they sit a test, I have a vlookup formula that takes their target grade, assigns it a numerical value, then I use a vlookup to get a numerical value for their latest test grade, subtract one from the other. If the result is either -1 or -2 (i.e. they are achieving their target or beating it) the cell turns green, if it is below zero (ie they are not yet hitting their target, it turns orange) if the result is -3 (ie they are way off their target) it turns red.

Is it possibly to achieve this in idoceo?

I would be happy if it just gives me the numerical answer of the calculation, that way I can set those as grade types and colour them accordingly.

I've attached my excel version so you have an idea.

Please help!
Last Edit: 7 years 6 months ago by dunkymunky.
The administrator has disabled public write access.

Conmparing two cells 7 years 6 months ago #4568

It wouldn't let me upload the file, here's a link to it
Last Edit: 7 years 6 months ago by dunkymunky.
The administrator has disabled public write access.

Conmparing two cells 7 years 6 months ago #4569

  • bert
  • bert's Avatar
  • Admin
  • Posts: 3371
  • Thank you received: 653
Hello dunkymunky,

In the current version of iDoceo, you can configure this but in a somewhat hacky manner.
Find attached below a sample which will give you an idea on how it's set up, 'Open In' iDoceo and type 1111 as its password.

However, we're now working on our next update, iDoceo 3.1 which will make this task a lot easier. It will soon be available, I'd say in about 2 weeks (here the details)

And here a screenshot of the new comparison and ranking features. Instead of those arrows, you'll be able to choose colors instead (red below, amber on target, green above)


PS: Don't worry about that Excel, the forum won't let you attach that file!
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
The administrator has disabled public write access.
Time to create page: 0.108 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

Read more


Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.