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.

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/)

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

It may require VBA.

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.

If you say so. Good luck.

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.

Formula:

Please Login or Register  to view this content.

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.

You're welcome. Thanks for the rep.

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.

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.

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

Originally Posted by Nvchicky

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).