+ Reply to Thread
Results 1 to 4 of 4

Enable calculation only on one sheet - conditional formatting

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Enable calculation only on one sheet - conditional formatting

    Hi Guys,

    i want to turn off calculation in one worksheet:

    Please Login or Register  to view this content.
    And my question is it will also turn off conditional formatting to not being calculate all the time? (it is volatile!)

    Please help,
    Jacek

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Enable calculation only on one sheet - conditional formatting

    Turning off calculation does not stop conditional formatting from working & AFAIK there is no way to prevent CF from working other than to remove it.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Enable calculation only on one sheet - conditional formatting

    Thank you !!

    Jacek

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Enable calculation only on one sheet - conditional formatting

    My pleasure

+ 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. Enable & disable conditional formatting using toggle button
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2015, 01:50 PM
  2. [SOLVED] Conditional Formatting not working anymore - Macro enable workbook
    By Lukael in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-20-2014, 11:43 AM
  3. Replies: 0
    Last Post: 03-13-2013, 12:05 PM
  4. [SOLVED] Formula help required to enable conditional formatting of cells that meet multiple con
    By Barbara Excel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2012, 10:10 AM
  5. Formula to enable sorting of conditional formatting
    By jpruffle in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-23-2008, 09:37 AM
  6. Enable conditional formatting
    By ukphoenix in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2007, 09:18 PM
  7. Replies: 1
    Last Post: 11-15-2005, 04:15 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