Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting (2000/SP3)

    Hello Everybody!

    I want to use the feature "Conditional Formatting" (hope, it's the right name for it, since I work with a german version of Excel) for the following: If the cells contains a formula, I want to format the cell in a special way, otherwise nothing should happen.
    Any ideas about this?

    Any help will be appreciated!

    Many greetings, Porley

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting (2000/SP3)

    Conditional Formatting is correct <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Create a user-defined function in a standard module:

    Public Function HasFormula(oCell As Range) As Variant
    HasFormula = oCell.HasFormula
    End Function

    Select the range of cells, say A1:A10.
    Select Format | Conditional Formatting.
    In the dropdown list, select Formula Is.
    In the box next to it, enter =HasFormula(A1)
    (In general, refer to the active cell within the selection)
    Specify the desired formatting, then click OK.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Germany, Germany
    Posts
    169
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (2000/SP3)

    Hello Hans!

    Thanks for this tip. It works perfectly well!!

    Many greetings, Porley

Posting Permissions

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