Forum Discussion
Solved
Conditional Formatting between certain dates
I have a date collumn and a number that was completed on that date. I want a forumla that will alert me if i try and put the same number on another row WITHIN 6 months of that first date. Exa...
This is what I get. I drew lines for the first occurrences.
Perhaps I misinterpreted your question. If so, please explain in more detail what you want.
Assuming that your data begin on row 1:
Select F2:Kn where n is the last used row.
F2 should be the active cell within the selection.
Create a conditional formatting rule of the formula type with the following formula:
=SUMPRODUCT(($F$1:$K1=F2)*($C$1:$C1>=EDATE($C2,-6)))
HansVogelaar That didnt work, They didnt highlight if they were within 6 months.