Real age V Test age - R A G formula needed

[cdnrohan1703]

I've done the formula to show the difference between actual age and test age, but can't get it to RAG colour using nested if then else. I'm using SIMS. Can someone help me with this please? Edited August 17, 2015 by cdnrohan1703

[GeekyPete]

What software is this in? If it's Excel Use conditional formatting on the cell. It works on the Value so you you can define your own ranges for R A G.

 

If this is SIMS/Integris/Arbor etc. I'm not sure.

[cdnrohan1703]

It's SIMS I'm using. Thank you

[bobsmith]

can you post a screenshot of your marksheet showing the calculation of the difference please?

 

also a screenshot of your nested if then else would be very handy.