Hi all
Can anyone help me with this problem:
I have two worksheets
In sheet1 i have columns: date1, ID number, name
In sheet2 i have columns: date2, ID number, name

To explain the purpose of sheets: in sheet1 i keep the records of people who had some kind of road accident. In sheet2 i keep records of people who attended safe driving education. People who had some kind of road accident should attend safe driving education (even if they attended it before the accident) so I would like to make a conditional formatting rule which will color column "name" in shee1 if the date2 is lesser than date1 for same ID number in both sheets. ID numbers in both sheets aren't in same order so person from sheet1, if exists in sheet2, isn't placed in same row in both sheets

help please