Compare a cell whit itself (conditional formating)

Closed
ArashMan
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
- Jan 18, 2015 at 01:01 AM
ArashMan
Posts
41
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 reply

ArashMan
Posts
41
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