+ Reply to Thread
Results 1 to 3 of 3

cell features to appear in formula

  1. #1
    Forum Contributor
    Join Date
    05-04-2015
    Location
    Colombo, Sri Lanka
    MS-Off Ver
    2010
    Posts
    121

    cell features to appear in formula

    hello friends,

    attached is a SAMPLE document where you will see that A7 represents a formula representing cells A1:A4.
    A1:A4 cells have different features such as some are bold, underlined, different in size etc.
    how can i get cell A7 to appear having same features of cells A1:A4?
    could we have a general VBA so that first it checks for bold, underlined text as per contents in the formula and thereafter it shows the exact contents as appearing in the selected cells.

    thank you

    regards
    rizvi
    Attached Files Attached Files

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,691

    Re: cell features to appear in formula

    Hi
    Not possible without VBA.
    Try this macro-
    This would loop through the specified number of rows starting from A1 and would copy color, size, bold, italics, underline property.
    Please Login or Register  to view this content.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Forum Contributor
    Join Date
    05-04-2015
    Location
    Colombo, Sri Lanka
    MS-Off Ver
    2010
    Posts
    121

    Re: cell features to appear in formula

    hi sourab,

    tried, but not working.....

    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. New features of Excel
    By GIS2013 in forum Suggestions for Improvement
    Replies: 2
    Last Post: 08-08-2015, 09:05 AM
  2. looking for help with macro combining formula, expansion and printout features
    By edegroote in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2013, 10:53 AM
  3. [SOLVED] Thanks for the new features
    By protonLeah in forum The Water Cooler
    Replies: 5
    Last Post: 04-12-2012, 02:48 AM
  4. Features I would like to see
    By 6StringJazzer in forum The Water Cooler
    Replies: 38
    Last Post: 11-03-2011, 12:38 PM
  5. Customised help features?
    By wonderdunder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-21-2010, 11:21 AM
  6. a formula using SUMIF or/and Lookup features
    By ExcelNewby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2007, 08:42 AM
  7. [SOLVED] Charting Features
    By mjones in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-08-2005, 08: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