Scale Conditional formatting based on formula

[Bluebell2012]

Hi. Hoping someone here can help, I have a conditional formatting query.

Ideally I want to format cell B2 based on the difference between cell C2 and B2 but with a colour scale.

So if B2 is 10 or more higher than C2 then i want B2 filled in a darker green.

if B2 is 1 to 5 higher than C2 then i want B2 filled in a pale green green.

Similarly going the other way in shades of red.

At the moment I'm doing this manually but if I can do this with conditional formatting that would save me a lot of time and hassle.
Any help or suggestions would be great.

Thanks

[Richard Buttrey]

Hi,
CFs in B2

Dark Green

Please Login or Register  to view this content.

pale green

Please Login or Register  to view this content.

[Bluebell2012]

Thank you so much Richard that sorted it.