Hello, I am trying to highlight a cell called "Job Date," if the date is between "Date of Visit," and "+45days." For example, I went to visit Customer A on 9/1/20 and got a job on 10/20/20, and went to visit Customer B on 9/15/20, and got a job from them on 10/20/20 as well. I would like to highlight the job date if it's within 45 days of my visit. My columns look like this
Date of Visit +45days Job Date
9/1/20 10/16/20 10/20/20
9/15/20 10/30/20 10/20/20
I am able to highlight one cell, but can't don't know how to copy that through the "Job Date" column since the comparison dates keep changing. Thanks in advance.
Bookmarks