+ Reply to Thread
Results 1 to 7 of 7

Highlight cells that are different

  1. #1
    Registered User
    Join Date
    06-14-2019
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    6

    Highlight cells that are different

    Hi trying to find a way to check cells where the code in the first column is the same, it finds the highest number in the group, highlights this green the then finds items around it that are different from green values and highlights in red as per attached screen shot....

    Not sure how to achieve this?

    Capture.PNG

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Highlight cells that are different

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    06-14-2019
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    6

    Re: Highlight cells that are different

    Hi Thanks have attached example file .. so I did a count of the number of country codes in column I count is in column K. Then based on the charge code in Column C find the line with highest count use as base highlight columns I to Y Green then check columns L to Y against base green row (charge code being index column C) any difference highlight in pink.
    Attached Files Attached Files

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Highlight cells that are different

    For Green, please try CF formula applies to $I$2:$Y$898

    =(MAXIFS($K$2:$K$898,$C$2:$C$898,$C2)=$K2)*($K2>1)


    Quote Originally Posted by ThereseW View Post
    any difference highlight in pink.
    I don't understand this part.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-14-2019
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    6

    Re: Highlight cells that are different

    based on charge code group want to see what fields have different values to the base row in green

  6. #6
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Highlight cells that are different

    Please try CF formula applies to $L$2:$L$898

    =(INDEX($L$2:$L$898,MATCH(MAXIFS($K$2:$K$898,$C$2:$C$898,$C2),$K$2:$K$898/($C$2:$C$898=$C2),))<>$L2)+(MAXIFS($K$2:$K$898,$C$2:$C$898,$C2)=1)
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-14-2019
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    6

    Re: Highlight cells that are different

    thank you worked a treat...

+ 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: 3
    Last Post: 05-19-2016, 06:21 PM
  2. Nested Loop inside pivot to highlight Cells, But Cells don't stay highlighted!
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2014, 05:00 PM
  3. [SOLVED] Count cells in row based on cell value, highlight row if wrong number or cells.
    By gutterball in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-11-2014, 04:00 PM
  4. Highlight cells for data entry but print workbook with no highlighted cells
    By kheino1111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2014, 06:51 AM
  5. Replies: 5
    Last Post: 05-18-2013, 07:49 PM
  6. Replies: 2
    Last Post: 10-24-2012, 11:47 AM
  7. [SOLVED] Highlight cells with ctrl-click but only un-highlight one cell
    By hagan in forum Excel General
    Replies: 5
    Last Post: 05-27-2005, 02:05 PM

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