Excel icon sets not working properly- Control conditional format icons
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
00:00 Understand how to control when conditional formatting will change
00:30 Edit Data Bars to be sized based on a specific number
02:34 Edit color scales to be based on your specific number
03:52 Edit conditional formatting icons to be based on a specific number
04:10 Reverse the icon order (risk robots)
04:38 Difference between 'Percent' and specific percent number (risk robots)
06:52 Difference between 'Percent' and specific completion percent (project milestones)
Follow Along File-19.1 in https://auditexcel.co.za/product-down...
Learn how to control the heat maps, data bars on icons so that they change based on exactly the number you chose. Often it looks like the icon set are not working in that they don't seem to change at the correct points, but this is just a setting which you can control (the Excel default setting is not ideal in this case)
Смотрите видео Excel icon sets not working properly- Control conditional format icons онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь AuditExcel Advanced Excel and Financial Model Training and Consulting 10 Май 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,608 раз и оно понравилось 9 людям.