+ Reply to Thread
Results 1 to 4 of 4

Bold latest entry in cell and unbold remaining entries in the same cell

  1. #1
    Registered User
    Join Date
    01-19-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Bold latest entry in cell and unbold remaining entries in the same cell

    Hey,

    Just querying if it is possible to do the following:

    As soon as somebody updates a cell which already contains text, the latest entry automatically gets formatted to bold and the entries below in the same cell become unbold.

    Example below, i want the 19/01/2016 line to be bolded and the 01/01/2016 now to be unbolded. Is there a way to automate this via a macro ?

    Cell C1:
    19/01/2016 Parker4001: We are mid way through January

    01/01/2016 Parker4001: Today is a new year

    Any help would be much appreciated.

    Thanks

    Parker4001

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Bold latest entry in cell and unbold remaining entries in the same cell

    It is possible but this does not seem like a good design to me. It is not practical to do any analysis when you are putting more than one data item into the same cell. I would recommend you enter this data on separate rows.

    How are you entering data? If you are using ALT+ENTER to force a line break in the cell, and the first line of text is always what is bolded, it is possible for VBA to do that. You would put this code into the module for Sheet1 (or whatever worksheet). You would also have to refine it to limit the action to the cells containing this type of data.
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-19-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Re: Bold latest entry in cell and unbold remaining entries in the same cell

    Thanks for the advice,

    Yes so i am using Alt + Ent to force a line break. So a typical example is here: All in E1

    21/12/2015 - Parker4001 to provide minutes

    18/12/2015 - Parker4001 to host meeting

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Bold latest entry in cell and unbold remaining entries in the same cell

    As I thought. Did you try my solution?

+ 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. Replies: 5
    Last Post: 07-06-2014, 11:41 PM
  2. [SOLVED] I need to be able to click on a cell to bold/unbold the number in the cell
    By giligancow in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-20-2013, 05:09 PM
  3. Following the latest entry and the past 2 entries
    By khank in forum Excel General
    Replies: 4
    Last Post: 06-13-2011, 02:39 PM
  4. Replies: 4
    Last Post: 04-27-2011, 05:08 AM
  5. Replies: 2
    Last Post: 02-06-2008, 07:27 PM
  6. Unbold cell in Column
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2007, 10:23 AM
  7. Changing text to Bold from another cell entry
    By TPD in forum Excel General
    Replies: 2
    Last Post: 09-19-2006, 02:31 PM

Tags for this Thread

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