Hello all,
I am trying to do conditional formatting to identify some emails based on how frequently they are on the sheet and when. I have the emails all listed in column H and dates listed in column B, data starts in row 2 for both. Basically I am trying to identify if an email pops up more than once on my list BUT ONLY within the last 30 days. If it pops up on the list beyond 30 days, it does not need to be highlighted or accounted for.
I currently have the following formulas, but they arent doing exactly what I need:
=AND(COUNTIF(H:H, H1)>=2, B1>=TODAY()-30)
=(COUNTIF(H:H, H1)>=2)*(B1>=TODAY()-30)
The problem is that if there are two emails on my list, one within 30 days of today and one beyond 30 days, the one within the last 30 days gets highlighted, however, I only want it to highlight if both appear within 30 days. I don't need it to consider emails beyond 30 days from today.
Does anyone have any ideas for a solution formula? Any help is greatly appreciated!
I am trying to do conditional formatting to identify some emails based on how frequently they are on the sheet and when. I have the emails all listed in column H and dates listed in column B, data starts in row 2 for both. Basically I am trying to identify if an email pops up more than once on my list BUT ONLY within the last 30 days. If it pops up on the list beyond 30 days, it does not need to be highlighted or accounted for.
I currently have the following formulas, but they arent doing exactly what I need:
=AND(COUNTIF(H:H, H1)>=2, B1>=TODAY()-30)
=(COUNTIF(H:H, H1)>=2)*(B1>=TODAY()-30)
The problem is that if there are two emails on my list, one within 30 days of today and one beyond 30 days, the one within the last 30 days gets highlighted, however, I only want it to highlight if both appear within 30 days. I don't need it to consider emails beyond 30 days from today.
Does anyone have any ideas for a solution formula? Any help is greatly appreciated!