Conditional Formatting

[TC123]

Hello,

I am looking for a bit of help. I would like cell D1 to turn red if the value in cell C2 is less than the value in cell C1. If the value in cell C2 is greater than the value in cell C1 I would like D1 to turn green. (The values in C1 and C2 are not fixed and are going to change so I think I need a formula please). Can anyone help?

Thanks

 

[JamesW]

Hi there,

Red: =IF(C2 < C1,1,0)<c1,1,0)> - without spaces.
Green: =IF(C2>C1,1,0)</c1,1,0)>