Ramadan2512
Board Regular
- Joined
- Sep 7, 2024
- Messages
- 68
- Office Version
- 2021
- Platform
- Windows
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
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