conditional formatting with years

Hi. The problem is like this: I have 2 columns. One with custom dates (dd mmm yyyy) and the other that needs to be conditional formatted by the first one. In the second one the highlighted values must be those that are between 20 and 30 years of service, calculated by the dates in the first column. Anyone have any ideea?

Why not add a worksheet so we don't have to guess what your data looks like? Or at least state exactly which columns you are using and where your data starts from and what values your second column contains.

Pete