+ Reply to Thread
Results 1 to 22 of 22

Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

  1. #1
    Registered User
    Join Date
    09-26-2023
    Location
    Nevada
    MS-Off Ver
    365
    Posts
    8

    Question Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    I have BOLD TEXT or Arial Black font that I need to copy to a new cell for display purposes. In the example below I want to duplicate a1 and c1 a9 and c9 etcetcetc into a different cell to make a list. All of the suggestions on line VBA, filter, etc all do not translate to a new cell. I need a new cell. This seems like a huge ask because noone seems to have found the solution. Again, BOLD TEXT or Arial Black are the variables to be used. The reason I need this particular solution is because this will be a living document and when I add more data it must show in the display list. Also, if I need tables, conditional text color, etc. anything I can do to get the necessary result. I have uploaded a snip of my excel worksheet. Also, I am using Windows 11 and Microsoft 365. Thank you so much in advice for your help in this matter.
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    Welcome to the forum.

    Sorry, but I have no idea where you are trying to make a list or how that replicates the formatting of other cells. I can tell you that anything involving formatting can't be done with a formula.

    Please explain again in clear detail what you want, where you want it, and what it should look like.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

    Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

    (Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...ables.1245846/)

  4. #4
    Registered User
    Join Date
    09-26-2023
    Location
    Nevada
    MS-Off Ver
    365
    Posts
    8

    Question Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    Hopefully this will help i have attached a Need This Result. Honestly as I say in my post I need a solution whatever it may be. So sounds like formulas are out but there are many other avenues of possibility I would hope. If this is to difficult for this forum just let me know. I would understand completely.excel bold text example.png

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    OK. So how is Excel to know that you want those values?

    It may require VBA.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  7. #7
    Registered User
    Join Date
    09-26-2023
    Location
    Nevada
    MS-Off Ver
    365
    Posts
    8

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    Again, however I need to do it. Things seem a bit difficult for this forum. I will go elsewhere thank you.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    If you say so. Good luck.

  9. #9
    Registered User
    Join Date
    09-26-2023
    Location
    Nevada
    MS-Off Ver
    365
    Posts
    8

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    How do I completely remove my account from this forum

  10. #10
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    I think the simplest way to go about this would be to use the fact that merged cells only contain the actual value in the upper-left hand cell to our advantage, so essentially you would be looking for all the values in column A where column B is blank.

    You can use a formula like this in N2 to do that:
    =FILTER(A1:A1000,(A1:A1000<>"")*(B1:B1000=""))

    Adjust the ranges as necessary to fit your data.
    Last edited by 63falcondude; 09-26-2023 at 01:43 PM.

  11. #11
    Registered User
    Join Date
    09-26-2023
    Location
    Nevada
    MS-Off Ver
    365
    Posts
    8

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    Oh my goodness that is incredible thank you so much. I also need the c1 and c9 information to correspond with A1 and A9. I attached a file showing an example in red text. Again, thank you so very much for your help. Hopefully, you can solve the rest of my problem!
    Attached Images Attached Images

  12. #12
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  13. #13
    Registered User
    Join Date
    09-26-2023
    Location
    Nevada
    MS-Off Ver
    365
    Posts
    8

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    You are a super star!!! Thank you so very much I truly owe you one. Lauren

  14. #14
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    You're welcome.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  15. #15
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    You're welcome. Thanks for the rep.

  16. #16
    Registered User
    Join Date
    09-26-2023
    Location
    Nevada
    MS-Off Ver
    365
    Posts
    8

    Question Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    I am wondering in the function =FILTER(A1:A1000,(A1:A1000<>"")*(B1:B1000="")) you gave me I have three questions:

    1.) Can we pull the font color and link in the above function.
    2.) Can I add a worksheet such as "QCla Titles" to the function so it shows on a new work sheet.

    Hope you can help. You have been amazing so far!!
    Attached Images Attached Images

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    I explained early in the thread that you cannot copy any formatting over using a formula.

    You CAN put the formula onto any worksheet, but you’d need to change the ranges to include the sheet name of the current worksheet.
    Last edited by AliGW; 09-28-2023 at 01:23 PM.

  18. #18
    Registered User
    Join Date
    09-26-2023
    Location
    Nevada
    MS-Off Ver
    365
    Posts
    8

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    I am not sure what you mean. I can take the formula to another forum correct and see if they can help. I truly am looking for help and not savvy enough to know about what your saying. I try and make the post really easy and detailed so there is no confusion. The person was kind enough to help me out and I was wondering that with their obvious command of excel they could just fine tune it a bit.

  19. #19
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    The formulae you have been given so far reference the sheet they are on. If you copy the formulae and put them on another sheet, they will reference the same cells on that sheet. It does not really make any sense adding a sheet name.

    That's why, in my reply to your PM, I asked you to post a sample workbook. Then we might have a better understanding of a) what we have helped you with so far and b) how we can help you in the future.

  20. #20
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    You can put this formula in any cell of the sheet 'QCla Titles':

    =FILTER('Standard Version'!A1:A1000,('Standard Version'!A1:A1000<>"")*('Standard Version'!B1:B1000=""))

    You can't pull the font color and hyperlink using formulas, but you can change the font color of the cells that the formulas were entered into in the 'QCla Titles' sheet.

  21. #21
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    I stand corrected. It does make sense to add a sheet name as 63falcondude has done. I just didn't understand the context.

  22. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: Duplicate cell to new cell using BOLDTEXT, Arial Black, font color, cell color etc..

    Quote Originally Posted by Nvchicky View Post
    I am not sure what you mean. I can take the formula to another forum correct and see if they can help. I truly am looking for help and not savvy enough to know about what your saying. I try and make the post really easy and detailed so there is no confusion. The person was kind enough to help me out and I was wondering that with their obvious command of excel they could just fine tune it a bit.
    I don't know why you keep saying that you can take the question elsewhere - we are all trying to help you!

    What I mean is this: let's say that you have a value in A1 and that value is MB45625. You change the font to Arial Black, you colour it red and you change its size to 18pt. Now in B1 you type =A1: the value MB45625 will now also show in cell B1, but it will NOT inherit the font, the colour and the size because a formula cannot bring that formatting across. Is this any clearer?

    The others have shown you how to put your formula onto another worksheet.

    You can COPY formatting from one cell to another: with the example I gave above, select cell A1 and right-click - copy. Now select B1 and right-click and select the paintbrush icon from the formatting options (this copies the formatting across).

+ 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. change cell color only if that cells font color is black and it's value is < 2000
    By randall78 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-05-2019, 05:23 PM
  2. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  3. how to automatically activate a macro when the font color in a cell changes to black
    By ainon ithnain in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2014, 03:52 AM
  4. Mouse rolls over to cell will change the tab color, font color and tp bold type
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2013, 10:36 AM
  5. Change font color based on font color of another cell
    By Ibyers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 09:36 AM
  6. Sorting by Cell Color, Font Color or Cell Icon in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-19-2007, 12:23 PM
  7. Fill Color and Font Color stay Black and White
    By Hors Categorie in forum Excel General
    Replies: 1
    Last Post: 05-10-2005, 07:20 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