Compare a cell whit itself (conditional formating)

Closed
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 18, 2015 at 01:01 AM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 20, 2015 at 11:18 PM
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 December 15, 2014 Status Member Last seen February 18, 2015 1
Jan 20, 2015 at 11:18 PM
guys i need your helps please.
i will appreciate your answers
thanks
0