So I have a list if things in a sheet. In the A column there are names, B column has a date, C column has a number and the D column has another date which is 5 days from the date in column B. I want to be able to come up with something that when someone's name is written into column A and if the date that gets placed into column D is within 5 days of the previous date of the same person in column D it will highlight the D column a color.
Example
Eric m ---- 6/25/21 ------ 3 --------- 6/30/21
Now if I enter that same name and the date in the second column is 6/27/21, I want the date that gets placed in column D to be highlighted.
Example
Eric m ---- 6/25/21 ------ 3 --------- 6/30/21
Now if I enter that same name and the date in the second column is 6/27/21, I want the date that gets placed in column D to be highlighted.
