I'm trying to format a single cell using conditional formatting to change the colour of the cell based on the following criteria, >=0 = Green, within 10% of the cell next to it Amber and if variance greater than 10% then Red. I'm sure I'm going about it the right way. Please help and please spell it out for me as I don't have much experience in this. Thanks