Forum Discussion
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.
Example:
January 4th - 4201
February 10th - 4201
I want it to highlight that because its WITHIN 6 months of each other.
Column information.
Date Column is C
Number Columns are F - O
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.
10 Replies
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.
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.
