Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting: ANY Formulas (2000)

    Hi

    I am looking to set a conditional format based on whether any values are calculated (formulas) as opposed to "hard numbers" (constants). I agree that this seems to be an extremely broad parameter to try to set. Any ideas?
    Gre

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Conditional Formatting: ANY Formulas (2000)

    Hi,
    I suspect you'll need a UDF for this. Something like:
    <pre>Function IsFormula() As Boolean
    application.volatile
    IsFormula = (Application.Caller.HasFormula)
    End Function
    </pre>

    You'll either need to have this in a module in the relevant workbook, or you could, assuming you have a Personal.xls or equivalent, define a name in your workbook ='Personal.xls'!IsFormula() and then refer to that name in your conditional formatting.
    That's off the top of my head so it may need refining a little, but I hope it helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •