I would like to conditional format a cell in sheet 2 column R when R matches sheet 1 column C:C and sheet 1 column D’s newest date is a year old or older. If that makes sense. Trying to highlight people that have no activity.