Conditional Formatting

Collection Activity Schedule.xlsx
Please help to create a conditional formatting formula.
Column F (125030045) also has the same values on Column G (Collected)
yet different dates on Column A
thanks for the help

Select F5:F7 and create a new conditional formatting usind a formula for a rule:

Formula:

Please Login or Register  to view this content.

In the attached file it formats cells interiors yellow

Thank you so much for the help but i think i was not able to explain the scenario.
CURRENTLY, STANDARD CONDITION on COLUMN J IS HIGHLIGHT CELLS WITH DUPLICATE VALUES.

17.03.25, CELL H18 , COLLECT CCM WAS COLLECTED ( COLUMN K-STATUS) AND No RGA (Column L-REMARKS)

LATER, CELL J18 WILL BE FILLED WITH NUMBER. THE PROBLEM OCCURS WHEN THE SAME NUMBER WILL BE INPUT.

THE PROBLEM STARTS WHEM THE NUMBER PUT ON THESE CELLS WERE THE SAME VALUES ON LATER DATE WHICH IS NOT THE SAME DESCRIPTION AS IN COLUMN H 125030167 DESCRIPTION (COLUMN H) COLLECT MAGNETRON HEAD, WAS NOT COLLECTED ON 18.03.2025
125030167 DESCRIPTION (COLUMN H) COLLECT MAGNETRON HEAD, WAS COLLECTED ON 19.03.2025

SO IF THIS CELL J18, WILL INPUT 125030167, IT WILL HIGHLIGHT THE ERROR
THAT THIS 125030167 IS DUPLICATE NUMBER, ALREADY COLLECTED WITH DESCRIPTION MAGNETRON HEAD ON 19.03.2025 AND DOES NOT MATCH WITH CELL H18 WHICH IS COLLECT CCM

Appreciate your help.
Collection Schedule.xlsx