Compare a cell whit itself (conditional formating)

Closed
ArashMan Posts 38 Registration date Monday 15 December 2014 Status Member Last seen 18 February 2015 - 18 Jan 2015 à 01:01
ArashMan Posts 38 Registration date Monday 15 December 2014 Status Member Last seen 18 February 2015 - 20 Jan 2015 à 23:18
Hello,
i want to know is that possible to compare a value of a cell with itself.
for example i enter "10" in cell B2
tomorrow i want to change it to "15" and i want to know is there any way that this cell goes red because 15 is bigger than 10
and it goes green if i enter any value less than 10

thanks for your useful responds.

1 response

ArashMan Posts 38 Registration date Monday 15 December 2014 Status Member Last seen 18 February 2015 1
20 Jan 2015 à 23:18
guys i need your helps please.
i will appreciate your answers
thanks