Change Color

I see the following patterns:

- colors are applied to cells with numeric values only, cells with "v" don't have special colors. 

- each row has its own unique highlight color

- you already have two conditional formatting rules to color cells based on their value "v" (light amber) or "ab" (pink)

You say that the colors relate to projects and that projects could change on a weekly basis. 

You could insert a column that specifies which project currently applies to the person. Then you can use conditional formatting and set up rules to format each cell with the project color if it has a number. Now you don't have to manually set the project colors and can apply the same conditional formatting

logic to the other sheets.

For example, insert a new column B after column A for the projects and enter the project names, in my example they are Project RED, Project AMBER and Project GREEN. Now create three additional formatting rules with formulas. The three formulas are (Starting with cell C4 and applied through to X6:

=AND($B4="Project RED",ISNUMBER(C4))

=AND($B4="Project AMBER",ISNUMBER(C4))

=AND($B4="Project GREEN",ISNUMBER(C4))

Insert the same column and conditional formats in all your sheets and get the project value from column B with a formula, like you do with the other values.

Now you can change the project values in column B and the colors will change accordingly.