+ Reply to Thread
Results 1 to 3 of 3

recalculate function

  1. 04-08-2017, 07:05 AM #1
    petenc
    petenc is offline
    Registered User
    Join Date
    02-22-2014
    Location
    Bruges, Belgium EU
    MS-Off Ver
    Excel 365 (into office 365)
    Posts
    12

    recalculate function

    Hi,
    my question is perhaps already answered because it is simpel:
    I want to colored a cell in red when the woorkbook is NOT recalculated and in green is it is.
    This should NOT be done by a VBA funtion. Is it possible ?
    Thanks in advance
    Constant Peten
    Reply With QuoteRegister To Reply
  2. 04-08-2017, 07:43 AM #2
    LewisJ
    LewisJ is offline
    Registered User
    Join Date
    03-17-2017
    Location
    Hell
    MS-Off Ver
    2010
    Posts
    172

    Re: recalculate function

    Hello,

    What is being calculated? I believe what you want is a highlight cell rule.
    Reply With QuoteRegister To Reply
  3. 04-08-2017, 07:47 AM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: recalculate function

    Hi,

    I don't know of any way other than VBA. Not even the old Excel4 Get.Cell function offers any help here.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Function won't recalculate
    By RayJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 05:17 PM
  2. Macro to recalculate function
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2007, 08:30 AM
  3. [SOLVED] Refresh/Recalculate a Custom Function
    By dch3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-31-2006, 09:03 AM
  4. [SOLVED] Recalculate function
    By Peter A in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2006, 02:25 PM
  5. My VBA Function Won't Recalculate
    By soteman2005 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2005, 10:55 AM
  6. cell function will not recalculate
    By Alexandre in forum Excel General
    Replies: 1
    Last Post: 06-17-2005, 06:05 AM
  7. function does not recalculate sum
    By lukiedukie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2005, 06:06 PM
  8. how to get a function to recalculate
    By Pb21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-02-2005, 10:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1