+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting with udf issues with Office 2016 / Office 365

  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    20

    Conditional formatting with udf issues with Office 2016 / Office 365

    Hi

    I have a UDF that checks for the existence of a comment. I use this in CF because I want to colour a cell if 1. The cell is not blank and 2. There is no comment. This has worked just fine with 2007 and 2010 but now I have 2016 and Excel has gone a little bit weird on me.

    UDF:
    Please Login or Register  to view this content.
    CF:
    =AND(NOT(ISBLANK(B6)),HasCmt(B6)=FALSE)

    Now when I meet the criteria, the formatting is applied and then goes away again. If I disable Automatic Calculation it behaves normally, until I recalculate. I also get errors upon saving the document. 'Calculation is incomplete...'.

    Does anybody know a fix I can apply to my many workbooks I have that use this CF? Did something change in the 2016 Excel offering?

    Any help would be greatly appreciated.

    Thanks

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Conditional formatting with udf issues with Office 2016 / Office 365

    Hi
    Try to remove Application.Volatile for your UDF HasCmt

    I hope this helps you.
    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. What's New and Improved in Office 2016 for Office 365
    By AlKey in forum The Water Cooler
    Replies: 5
    Last Post: 05-06-2016, 07:52 AM
  2. [SOLVED] VBA on Office 2016 for Mac
    By pclaesen in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 03-21-2016, 05:06 AM
  3. Replies: 1
    Last Post: 01-31-2016, 07:46 AM
  4. Update from Office 97 to Office Professional Plus 2016
    By billd73 in forum Excel General
    Replies: 0
    Last Post: 12-28-2015, 05:15 PM
  5. Default excel template in Office 2016?
    By honeybadger_rgr in forum Excel General
    Replies: 0
    Last Post: 12-10-2015, 12:19 PM
  6. [SOLVED] Implement office 2016 version
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2015, 01:32 PM
  7. Office 2016 Is it worth Upgrading?
    By TwistedFaith in forum Excel General
    Replies: 0
    Last Post: 08-25-2015, 06:10 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