Hi Guessed,
Please find attached my mockup document.
I have desensitised the document and shown where the effectiveness Tables are by highlighting the first columns of the tables in blue.
The Part that I want to change colour depending on it's Value is the second cell in the first row.
Weak = Orange (White font)
Effective = Blue (White font)
Adequate = Green (White font)
Not Applicable = Purple (Black font)
Regards,
Julian
|