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.
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.
- The formula is on my spreadsheet in 3 different sections, its working perfectly for 2 of the 3 locations, The 3rd location on the tracker the formula is almost upside down, Instead of highlighting the 2nd date being within 6 months, its highlighting the first date.
