View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Lincoln
 
Posts: n/a
Default Conditional formatting and formula

This way should work:

=DATEDIF(J3;TODAY();"y")2

First of all, you had the "3" test within the DATEDIF function.
Secondly, DATEDIF will return only the whole number of years between
the two dates. So if the formula equals 3, there are at least 3 years
between the dates. That's why you want to test for 2.