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
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
Last edited by angie_lin; 03-20-2025 at 09:56 AM.
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
Best Regards,
Kaper
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
Last edited by angie_lin; 03-20-2025 at 09:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks