Find Duplicates and change font color based on other cell value

[Ramadan2512]

I have a table with cell value (Codes) in column "E"and date value in column "I"
and because of these codes might be duplicated many times while I need only maximum two cells can be valid with the same code based on the date value in "I" if >=TODAY().
so I need a help please to check if there are more than two cells value duplicated in "E" and have a date in "I" >=TODAY() then to change the these cells font color to red

can you help me please how to do thatwith a formula or conditional formatting

 

[etaf]

a count
=COUNTIFS($E:$E, $E1,$I:$I,">="&TODAY())>1

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A1:I100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=COUNTIFS($E:$E, $E1,$I:$I,">="&TODAY())>1

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book3
	A	B	C	D	E	F	G	H	I
1					code
2					a				9/9/24
3					bc				9/9/24
4					code				9/9/24
5					d				9/9/24
6					e				9/9/24
7					f				9/9/24
8					g				9/9/24
9					h				9/9/24
10					f				9/9/24
11					a				9/9/24
12					d				9/9/24
13									9/9/24
Sheet1

Cell Formulas
Range	Formula
I2:I13	I2	=TODAY()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:I13	Expression	=COUNTIFS($E:$E, $E1,$I:$I,">="&TODAY())>1	text	YES

 

[Ramadan2512]

a count
=COUNTIFS($E:$E, $E1,$I:$I,">="&TODAY())>1

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A1:I100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=COUNTIFS($E:$E, $E1,$I:$I,">="&TODAY())>1

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book3
	A	B	C	D	E	F	G	H	I
1					code
2					a				9/9/24
3					bc				9/9/24
4					code				9/9/24
5					d				9/9/24
6					e				9/9/24
7					f				9/9/24
8					g				9/9/24
9					h				9/9/24
10					f				9/9/24
11					a				9/9/24
12					d				9/9/24
13									9/9/24
Sheet1

Cell Formulas
Range	Formula
I2:I13	I2	=TODAY()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:I13	Expression	=COUNTIFS($E:$E, $E1,$I:$I,">="&TODAY())>1	text	YES

thank you so much

 

[etaf]

you are welcome