1,582 views
#msexcel #indrakohl #conditionalformatting ▬▬ Content In this video we show you how to bring color into play in Excel tables ;-). You can not only define this permanently, but also link it to conditions. For example, by entering a number (ID) or text (sick, vacation, ...) it is possible to automatically fill the cell with the desired value (VLOOKUP) or have Excel color it. We can even do it so that the entered value remains invisible. Such color codes are particularly helpful when planning deployments and projects and make it easier to see and evaluate the input. Have fun! 00:00 Tips & tricks for setting up templates with automatic date transfer, simultaneous filling of empty cells, and much more 05:43 VLOOKUP for retrieving values from auxiliary tables 07:05 Use of conditional formatting If Then Color ▬▬ Regular EXCEL campaigns at http://aktion.excelexperte.com ▬▬ Do you value our work and want to support us? https://paypal.me/carinkokohl Thank you very much!!! ▬▬ More information Stay up to date and visit our blog: https://www.carinko.com/blog. You can find individual courses, document templates and much more in our shop: https://www.carinko.com/shop. ▬▬ Even more for you We are also happy to support you in creating Excel templates, tables & lists or individual Excel sheets based on your specifications & wishes. Send us your request by email to [email protected] for an individual offer.