+ Reply to Thread
Results 1 to 2 of 2

Highlight cells with reference to another column

  1. #1
    Forum Contributor
    Join Date
    08-27-2016
    Location
    INDIA
    MS-Off Ver
    2003,2007,2010
    Posts
    134

    Question Highlight cells with reference to another column

    All masters,

    Need conditional formatting or any formulas method for Highlighting cell range column "C", with reference to "J" column range values.

    or example: at "J2" value is "902000799" so at "C" column, this "902000799" value we can find at "c" column is at "C492" cell. so i want the fill with red color at "C492" cell

    and at "J3" cell value is 903000436, we can found at "C63" cell. so i want the fill with red color at "C63" cell.
    and at "J4" cell value is 903000438, we can found at "C104" cell. so i want the fill with red color at "C104" cell.

    same like reaming cells at "C" column filled by red color with reference to match "J" column by equal values comparison.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,147

    Re: Highlight cells with reference to another column

    Coditional formatting

    =MATCH($C1,$J:$J,0)

    Set FILL to "RED"

+ 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. Replies: 5
    Last Post: 01-12-2017, 04:34 AM
  2. [SOLVED] highlight duplicate reference numbers in column A
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-06-2014, 04:57 AM
  3. [SOLVED] Highlight Cells based on Cell Reference on another Worksheet
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-28-2014, 08:24 AM
  4. Replies: 2
    Last Post: 04-17-2014, 03:30 PM
  5. Replies: 4
    Last Post: 01-03-2013, 12:25 AM
  6. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  7. Replies: 1
    Last Post: 09-19-2009, 08:09 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