I am trying to do conditional formatting on a column whose contents are dates formatted as follows: xx/xx/xx. I amtrying to highlight every cell that is GT 01/01/2005. When I apply the formatting it highlights cells that contain for example 01/01/2004. Why is that? Any help would be appreciated.