Even Excel's own inbuilt cell styles now fail their own accessibility checker tool. Coolers gave up some interesting options, when starting with yellow as a logo colour.
I wasn't aware of that, Andrew! I have to admit I don't use the accessibility checker much. Great to see you checked out the colour scheme website - at the very least it gives you ideas. Thanks for the comment!
Hi Chris any advise on how to deal with different countries formatting of decimal points and thousand denominations in excel when using VBA formatting would be greatly appreciated no one seems to have covered it on you tube
Will you be showing how to create a user form with multiple pages? And can the user form recall the original entries on all the tabs/pages on a user form?
Hi there - such a video is possible. I have found multipage userforms fairly easy to implement and there are many guidance resources out there, good luck!
Hi Chris, any tips for customizing the entire color palette in addition to using Coolors? Looking for helps so that graphs and charts look nice across Excel and PowerPoint.
Great question - but I would apply the same approach as here. Limit your palette to 4-5 colours - don't worry about customising lots of colours (64?) Save the RGB / Hex codes for these 4-5 and use them in the file so they appear as easily-accessble options. Use paste special / formats (in Excel) and the format painter (in Powerpoint) to quickly transfer a look from one element to another. Keep it simple ... and beautiful!
Do not rely on Excel default color sequences in charts to be effective for color blind users. In addition to looking up recommended color segmentation for readability for color blind, also change the texture of lines in charts to help. I recommend adding a color to designate user data input cells and unlocking those cells while leaving your formula cells non-colored and locked.
Don't be so hard on yourself, Chris. When I was growing up in the 70s, magenta and yellow WERE complimentary colours, second only to orange and brown, of course. Give it another 10 years, and that spreadsheet will be back in fashion... 😁
Do you plan to use this colour scheme generation technique in your Excel work? Let me know right here in the comments ...👇
Thank you, this is a brilliant tip 😍
You're welcome! See you in another video on the channel ...
Even Excel's own inbuilt cell styles now fail their own accessibility checker tool. Coolers gave up some interesting options, when starting with yellow as a logo colour.
I wasn't aware of that, Andrew! I have to admit I don't use the accessibility checker much. Great to see you checked out the colour scheme website - at the very least it gives you ideas. Thanks for the comment!
Hi Chris any advise on how to deal with different countries formatting of decimal points and thousand denominations in excel when using VBA formatting would be greatly appreciated no one seems to have covered it on you tube
Will you be showing how to create a user form with multiple pages? And can the user form recall the original entries on all the tabs/pages on a user form?
Hi there - such a video is possible. I have found multipage userforms fairly easy to implement and there are many guidance resources out there, good luck!
Hi Chris, any tips for customizing the entire color palette in addition to using Coolors? Looking for helps so that graphs and charts look nice across Excel and PowerPoint.
Great question - but I would apply the same approach as here. Limit your palette to 4-5 colours - don't worry about customising lots of colours (64?) Save the RGB / Hex codes for these 4-5 and use them in the file so they appear as easily-accessble options. Use paste special / formats (in Excel) and the format painter (in Powerpoint) to quickly transfer a look from one element to another. Keep it simple ... and beautiful!
Do not rely on Excel default color sequences in charts to be effective for color blind users. In addition to looking up recommended color segmentation for readability for color blind, also change the texture of lines in charts to help.
I recommend adding a color to designate user data input cells and unlocking those cells while leaving your formula cells non-colored and locked.
Great tips Geoffrey, thank you!
Don't be so hard on yourself, Chris.
When I was growing up in the 70s, magenta and yellow WERE complimentary colours, second only to orange and brown, of course.
Give it another 10 years, and that spreadsheet will be back in fashion... 😁
😂😂😂there's a kind of 'circularity' here