### iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here

## Conmparing two cells 7 years 6 months ago #4567

 dunkymunky OFFLINE New member Posts: 2 Hi 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

 dunkymunky OFFLINE New member Posts: 2 It wouldn't let me upload the file, here's a link to it onedrive.live.com/redir?resid=6265FEB898...Q&ithint=file%2c.xls 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

Time to create page: 0.108 seconds

#### Recently updated articles

21 AUG

iDoceo 7 for iPad and Mac now available!

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

6 JUN

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