+ Reply to Thread
Results 1 to 2 of 2

Able to find text properties?

  1. #1
    NavEEd
    Guest

    Able to find text properties?


    Is there a function in excel to test the text properties of a cell. ie. if
    it's bold or red color text?

    thanks

    naveed010@hotmail.com



  2. #2
    RagDyer
    Guest

    Re: Able to find text properties?

    G0 to the Help files, and lookup
    Cell worksheet function

    That will give you a list of the types of formats that can be returned.

    Mostly date, time and currency formats.
    The only color return would be the "negative red" in currency.

    What you're looking for needs code.
    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================


    "NavEEd" <naveed010@hotmail.com> wrote in message
    news:bOMcf.122058$Ph4.3743127@ursa-nb00s0.nbnet.nb.ca...
    >
    > Is there a function in excel to test the text properties of a cell. ie.

    if
    > it's bold or red color text?
    >
    > thanks
    >
    > naveed010@hotmail.com
    >
    >



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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