+ Reply to Thread
Results 1 to 3 of 3

Excel makes certain cells pink when sorting?

  1. #1
    Registered User
    Join Date
    08-03-2016
    Location
    Phoenixville
    MS-Off Ver
    MS Office 2013
    Posts
    14

    Excel makes certain cells pink when sorting?

    Using a project list spreadsheet. Columns are arranged: Job #, Name, City, State, Client, etc.

    Sorted jobs based on Client. When doing this, certain "Job #" cells were formatted with a pink background/red text. This usually indicates that there is a duplicate cell, but having checked, there are no duplicate cells with the same value in them.

    Why is excel formatting them when sorted, if there are no duplicates? How can I fix/turn this off? Or check what it thinks it is indicating?

  2. #2
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2013
    Posts
    142

    Re: Excel makes certain cells pink when sorting?

    Click on the Conditional Formatting button and select "Manage Rules".

    In the box for "Show formatting rules for:" select "This Worksheet"

    This will show you a list of all the conditional formatting rules that are set for that particular worksheet. You can then edit or delete the rules.

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Excel makes certain cells pink when sorting?

    Select the column of interest, Home tab > Conditional Formatting > Clear rules ...
    Entia non sunt multiplicanda sine necessitate

+ 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. excluding cells from average that are colored pink
    By tippyio in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2014, 02:03 PM
  2. Replies: 3
    Last Post: 04-19-2013, 03:07 PM
  3. [SOLVED] Gray out cells until user makes input
    By jbeeball in forum Excel General
    Replies: 3
    Last Post: 05-21-2012, 12:48 PM
  4. A dll call in vba makes excel bug ???
    By alpha35 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2007, 12:59 AM
  5. How do I make my borded automatic black instead of pink?
    By Brenda in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2006, 04:34 PM
  6. [SOLVED] Print pink sheets
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2006, 11:55 AM
  7. Replies: 1
    Last Post: 07-20-2005, 09:05 AM

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