Excel VBA: The Ultimate Cell Formatting Masterclass + FREE Cheat Sheet

[@ExcelForFreelancers]

😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment

[@DennisvanRosendaal]

Thank you again Randy, I have watched and downloaded all the vba workbooks until nr 13 now and your way of teaching is very easy to understand. Learning more along the way

[@ExcelForFreelancers]

Great thanks so much Dennis. I am so glad you enjoy the training. Thank you for your Likes, Shares & Comments. It really helps.

[@justjimjpc]

Randy, This is good stuff .... I added a second rule to turn the Income lines to Green. I also ran the Format multiple times ... This creates incomplete Rules being added to the Conditional Formatting Rules list. To fix this I added a line of code just before the formatting rules lines of code as follows: .Range("A1:F" & LastRow).FormatConditions.Delete .Range("A3:F" & LastRow).FormatConditions.Add xlExpression, Formula1:="=$F3=""Expense""" .Range("A3:F" & LastRow).FormatConditions(1).Interior.Color = RGB(255, 153, 204) .Range("A3:F" & LastRow).FormatConditions.Add xlExpression, Formula1:="=$F3=""Income""" .Range("A3:F" & LastRow).FormatConditions(2).Interior.Color = RGB(181, 230, 218) This assumes that you are creating all your rules in this macro... otherwise any other previous conditional rules will be lossed / deleted. Hope this helps someone else.

[@ExcelForFreelancers]

Oh that is really smart. Very well done. I can see how that would be a huge benefit. Thank you for your Likes, Shares & Comments. It really helps.

[@nerenlakhraj5252]

Always something to learn. Thanks Randy for your continuous training

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Neren. I am happy to help and share

[@temyraverdana6421]

Incredible idea. Thanks a lot

[@ExcelForFreelancers]

For sure, you are very welcome and I am very happy to help

[@Jumbolata]

Thanks so much Andy. You videos are very helpful. Keep doing the good job @

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@SyedMuzammilMahasanShahi]

Thanks Randy for this video.

[@ExcelForFreelancers]

For sure, you are very welcome Syed and I am happy to help and share

[@navadgiarun]

Very nice tutorial sir much appreciated

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and so glad you enjoyed it

[@henkvinck888]

Great, fun video, having template change color by color button would be something I would enjoy in the coming lessons. THNX RAndy

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Henk. I have a bit of that here: kzbin.info/www/bejne/eaLUpoqibrGarsk Thank you for your Likes, Shares & Comments. It really helps.

[@teoxengineer]

So useful tutorial and a lof of benefits. Thank you so much.

[@ExcelForFreelancers]

For sure, you are very welcome and glad i could help

[@intakhabkhan9649]

Thank you so much for your continue uploading informative and valuable video. I appreciate if you can provide one video related to 'Procurement Management' with complete process from start to end.

[@ExcelForFreelancers]

HI and thanks very much. I have most of that here: kzbin.info/www/bejne/r3eph4tmmrKfe7M I hope this helps and thanks so much.

[@laminulams8723]

Please teach us how to design the background, or the process even once. Thanks for the support you always gives us Randy.❤❤❤

[@ExcelForFreelancers]

HI and thanks, for sure I will, thank you. I will get to that in an upcoming video. Much appreciated

[@shaharyarahmed6124]

You are king of vba

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@guillermohernandez-trejo9045]

Thank you Andy, so helpful, I have a question: Why you use Chart(34) in one of the format you teaching us? Also you use := in one of the samples. What does that mean? If you can explain please. Thanks again from North Carolina, USA.

[@ExcelForFreelancers]

Hi and thanks very much Char(34) is the quotation mark character. Let's say O want VBA to enter a formula in a cell, and that formula contains a quotation mark. I use Char(34) instead of the quotation mark so that VBA will properly enter a formula into the Excel formula. I hope this helps and thanks so much.

[@shaharyarahmed6124]

Sir please make a video for Invoice settlement, adjustment please

[@ExcelForFreelancers]

Hi and thanks I have many Invoices that can be used, please check my playlist here: If you can't find anything that fits, please let me know the details of how a 'settlement and adjustment invoice should be different. I hope this helps and thanks so much.

[@samirasoulaf5664]

Please create a video that explains how to draw geometric shapes using a data entry form, with the ability to change their dimensions and sizes interactively. This video will help me to draw reinforcement details in civil engineering.

[@ExcelForFreelancers]

HI and thanks very much. This may be a bit complicated and confusing for most people so i am not sure if it would generate interest and views for the masses, however, I will write the idea down, and If i get enough requests, I will certainly consider it. Thank you for your Likes, Shares & Comments. It really helps.

[@samirasoulaf5664]

Thank you for your interest

[@Chem.digital.study_tools]

hello can you please make a video on speech recognition ,if its possible ,like making a workbook with voice dictate

[@ExcelForFreelancers]

Hi and thanks very much. Microsoft Windows already had a built-in speech recognition tool that will work with any application on your computer. I hope this helps and thanks so much.

[@Chem.digital.study_tools]

cant i use vba to manipulate or dictate specific action by voice maybe if i want to run any macro just by voice input @@ExcelForFreelancers

[@ExcelForFreelancers]

Hi and thanks, perhaps, there is a thread on that here: www.macrodroidforum.com/index.php?threads/how-to-run-a-macro-by-voice-command.4121/ I hope this helps and thanks so much.

[@Chem.digital.study_tools]

thank you i will do more research on this @@ExcelForFreelancers

[@ExcelForFreelancers]

For sure, you are very welcome

[@jesusaburtocruz2217]

Hola Randy, eres un crack en vba, mi pregunta es: Si manejo el formato condicional desde vba, reduce el tamaño del archivo? Saludos.

[@ExcelForFreelancers]

Hola y gracias por tu comentario y me alegra que hayas disfrutado el vídeo. Utilizo formato condicional en casi todas las plantillas, sin embargo, crea un tamaño de archivo mayor. Si le preocupa mucho el tamaño del archivo, entonces es mejor un formato menos condicional. También es inteligente limitar el formato solo a las celdas utilizadas (no desea formatear filas o columnas enteras) Espero que esto ayude y muchas gracias.

[@shaharyarahmed6124]

Kindly make a video Excel with dynamic ax 2012

[@ExcelForFreelancers]

HI and thanks very much for the suggestion. I will do my best to get that added in the near future. Thank you for your Likes, Shares & Comments. It really helps.

[@pawemajewski2430]

Hello i am happy you creating very good material i can lear :). ANd there is question. Can we create a button like when i click on it and realize i make mistake but i still hold mouse button and go back from this to avoid swith on like on normal button html or windows ? possible ? because i create nice looking button but this is normal macro and doesnt work like real one. Please let me know if possible thanks.

[@ExcelForFreelancers]

HI and thanks, yes for sure. You can undo any action, using a change history training I have here: kzbin.info/www/bejne/bIXRqYOsgd-SapY I hope this helps and thanks so much.

[@pawemajewski2430]

@@ExcelForFreelancers this is not what i mentioned. You show me a button un do and i want create a button like active comman button. I dont know how to explain... You clock on IT and... When this is a shape with Marco assigned you cant unclick When you realize this is not what you want open or what ever this button is assigned. But witch build in button you can by still holding mouse button and drag out from button position. I Hope i explain this clearly because by english isn't good :)

[@ExcelForFreelancers]

Hi and thanks for your updated details. I am not aware of any solution for this in Excel. I hope this helps and thanks so much.

[@TheJeffunsal]

How do I get AI Toolpack?

[@ExcelForFreelancers]

HI and thanks very much. You can get the AI toolpack from here bit.ly/AIToolpack_RandyShared I hope this helps and thanks so much.

[@designexperience]

Hi Randy, Please I'm trying to create a folder in my OneDrive storage programmatically with VBA... Can you help me please..... I kept getting error 52 and 76. Thanks in advance

[@ExcelForFreelancers]

Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@ExcelForFreelancers]

⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack