Colour Calculation

[RussChilds]

Hi,
I have 3 columns with numbers in each column. I want to use colour to show if there is a difference of more than 10. For example if Joe Bloggs scores A1 = 89, B1 = 96 C1 = 124. I would like C1 to highlight in colour to show its more than 10 difference to A1 & B1.
Hope that makes sense.
Many thanks,
Russell

 

[JackDanIce]

Select C1, and then you need conditional formatting of:

=AND(C1-B1>10,C1-A1>10)

And then set the format for whatever colour you want if result is TRUE

 

[RussChilds]

Cheers!!! Very helpful

 

[JackDanIce]

You're welcome