Following is the procedure to change the color theme in our HR templates.


Unhide and unprotect all worksheets on the template:

How to unprotect?


The color scheme used in our template is as shown below:




To change the color theme, go to Page Layout -> Colors ->Customize Colors as shown below:



Then replace the color with the required colors. For example, if you want to change the yellow color, you need to change ascent 3 as shown in the first image, for brown change Ascent 2 and background dark 2.


Note: Please protect the sheet again to ensure the formulas are not deleted accidentally.