I client recently requested me to align the colors used in all their apps' objects to their corporate colors
To avoid having to edit each app again in the future if the color requirements change, I decided to create a method to populate the color variables from excel, thus next time I simply have to update the color codes in the excel file
To scale this approach out to other future implementations, I have created the attached .qvf file and excel files.
The app also includes examples of how to incorporate colors using certain functions / methods:
- ColorMix()
- Data Brushing
- Pick()
- Pick(Match())
I also included my list of useful color related websites to help you with color selection and design