+ Reply to Thread
Results 1 to 7 of 7

colouring sheet by CF

  1. #1
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    colouring sheet by CF

    Hi,

    I've received email today from one of my colleague, more less like:
    "Could you take a look on sheet X.
    Is always hidden, calculates properly, but I need to change some parameters for next year and I can't working comfortably with it.
    Terrible interruption while scroll with scrollbar or using arrow / pageUp /pageDown....."

    I've opened this sheet and indeed scrolling was practically impossible.
    Data were spread around A1:BM800, so small bunch of. I've check used range, was quite matching. No weird formulas, couple of errors on results.... but nothing explained this behaviour.
    After some time (I have no idea what to check), I've spot that data are so colourful and try to check CF setting..... When I was trying to open CF rules manager, I was waiting around 45 seconds to display it!!
    So I've used VBA:
    Please Login or Register  to view this content.
    and quick contest how many CF rules have been set?
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,761

    Re: colouring sheet by CF

    Why have you posted this in the Water Cooler? Was this a mistake?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: colouring sheet by CF

    "Water Cooler" - A place for relaxed off-topic discussions, getting to know your fellow members or idle chit chat!

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: colouring sheet by CF

    No one dare to guess (maybe I should describe a issue better, sorry English is not my native language).
    There were 7196 rules! Yes! Seven thousands one hundred ninety six rules in single sheet.
    So, I am not surprise that xl has a problem with proper and fast displaying.

  5. #5
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,950

    Re: colouring sheet by CF

    Are they unique rules or the same rules repeating itself for multiple ranges that seems to happen when data is added?
    Also worth checking the number of Styles as these can also build up.

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

    Re: colouring sheet by CF

    Don't think KOKOSEK is trying to solve a problem, but merely showing something out of the ordinary. And I must say that 7000 + CF rules is really unusual

  7. #7
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,950

    Re: colouring sheet by CF

    Understood and I note that this is in the WaterCooler, but having said that, I imagine he fixed it.

+ 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: 15
    Last Post: 06-27-2018, 07:14 AM
  2. Colouring a graph
    By rjc_29 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-18-2015, 08:41 AM
  3. [SOLVED] Colouring loop
    By GoonerJed in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-26-2013, 07:37 AM
  4. IF AND function for colouring the whole row
    By sam sam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2012, 08:20 AM
  5. transfering colouring
    By davidrose in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-23-2012, 07:59 AM
  6. Colouring cells
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 11-04-2011, 11:14 AM
  7. colouring a cell
    By andy617 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2006, 11:35 AM

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