+ Reply to Thread
Results 1 to 5 of 5

conditional formatting

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    49

    conditional formatting

    Hi all
    Just wondering if you could help with a query. I have a fairly large spreadsheet using around 2500 rows and 30 or so columns. I have some conditional formatting that I want to clean up. One column in particular is formatted to highlight duplicate data. I now have dozens of these rules in that column from where I insert new rows and the format copies, but that is ok I understand that happens. I have noticed though that there are also dozens of other 'n/a' rules that I didn't put in and I wonder what they are for and is it safe to delete them? In the C/F Rules Manager box the rules are listed as below:

    Rule Applies To
    Duplicate Values =$B$1485:$B$1486
    Cell value = "n/a" =$B$1485:$B$1486
    Cell value = "n/a" =$B$1485:$B$1486


    any ideas on this?

    thanks
    Steve

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: conditional formatting

    You can try deleting one of them to see if it has an adverse effect in your sheet. If it does, then close the workbook without saving, if it doesn't then do the same for the rest of them.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,419

    Re: conditional formatting

    It's only two cells, repeated for some reason. Someone else, or you, may have added it inadvertently, or for testing purposes.

    In any case, if you delete them both, you won't lose much. You could always put it back but, if you don't know why it's there in the first place, why would you?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    07-04-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: conditional formatting

    Thank you
    i have gone through and deleted all of them - right across several of the columns. There were a lot more than i thought there would be, as well as several other conditional formats that had mysteriously appeared in columns where they shouldnt have been. I dont know how they got there but hopefully I now have them all removed for good. It seems to have done the trick though as it now seems to work much more speedily

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,419

    Re: conditional formatting

    It seems to have done the trick though as it now seems to work much more speedily
    Extensive CF can have a dramatic effect on performance.

+ 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: 1
    Last Post: 12-08-2016, 03:14 PM
  2. Replies: 2
    Last Post: 10-03-2016, 08:35 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

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