+ Reply to Thread
Results 1 to 2 of 2

Change the cloour of Highligted duplicate values

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Change the cloour of Highligted duplicate values

    Hi,

    Is there any way to change the duplicate highlighting (by default its dark red) color to any other colour by default.

    There is an option to change in the tab CF>Highlight Cell Rules>Duplicate values but we need to change it every time whenever i m working with different excel or different columns.

  2. #2
    Forum Contributor
    Join Date
    02-07-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    290

    Re: Change the cloour of Highligted duplicate values

    Hi,

    To answer your question in Simple words is "No".

    This link explains more

    A work around is:
    Make one CF of your chosen color, then instead of making new CF rules on new sheet/data, try copy/paste the previous (chosen) CF, now just edit the range to suite.

    Regards,

+ 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. is there anyway to change this code to not allow duplicate values in combobox
    By justlearning123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2015, 04:19 PM
  2. [SOLVED] Macro to find duplicate values in different workshhet and change cell colour.
    By Gaztr1x in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2015, 04:12 PM
  3. change code of combobox to not duplicate values
    By matwork in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-16-2013, 09:16 AM
  4. change all duplicate values..............
    By sanjoy.dutta in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2013, 10:31 AM
  5. If Duplicats in col A, I need differences in other colls to be highligted
    By J0ck3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2013, 09:55 AM
  6. Replies: 4
    Last Post: 07-30-2012, 04:21 PM
  7. How can I find duplicate values in a column and then change the value of a cell?
    By Excelcod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2011, 02:59 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