+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting

  1. #1
    Registered User
    Join Date
    09-28-2017
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    28

    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
    Last edited by angie_lin; 03-20-2025 at 09:56 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,873

    Re: Conditional Formatting

    Select F5:F7 and create a new conditional formatting usind a formula for a rule:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    In the attached file it formats cells interiors yellow
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    09-28-2017
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    28

    Re: Conditional Formatting

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Formatting based on another cells Conditional Formatting
    By chriskay in forum Excel General
    Replies: 4
    Last Post: 08-22-2019, 05:33 AM
  2. [SOLVED] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1