I am a supporter ofSt. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation toSt. Joseph's, please.
Information onSt. Joseph's
If you need to keep track of extreme values of a cell you can use the VBA code as shown below. The code works for numbers as well as for text.
If you are interested in downloading a 20 KB Excel 2010 © sample file which contains the code shown here, go to my Download page, please.