0
Good night, you guys.
I reached my limit of reason with excel.
I created a template for a checksum checklist. However, when inserting more rows dynamically, through the use of userform, excel simply does not respect the formatting of the first row of the table randomly.
In addition to not formatting A3 as "Currency" and losing alignment, H3 and J3 are having a font color change.
To complete, I would like to know if it is possible to preserve the existing Conditional Formatting in F2:M2, and the table is dynamic. I intend, in the future, to make a form through macro appear whenever a "new sheet" is added, so that the table is generated from scratch (that is, not even the A2 line will exist). It is possible to do conditional formatting by VBA?
Your question seems to have some problems and your experience here in Stack Overflow may not be the best because of it. We want you to do well here and get what you want, but for that we need you to do your part. Here are some guidelines that will help you: Stack Overflow Survival Guide in English (short version). If the solution is very simple it is still possible for someone to do so in the comments.
– danieltakeshi
Describing the general problem you will get only a general answer. Example: "How to build a house?" , "Use blocks and cement, build solid walls". Instead ask something specific and responsive in a useful way: "How to lift a wall using this type of block with such a slope and such height safely?" , answer: "Position the blocks in such format, run this block placement algorithm, do not use this tool because there is such a risk, here is an example running from a wall ready for you to see how it does [link]". See? Too many wide questions don’t help.
– danieltakeshi