Hi Forum,

I'm new to VBA but slowly learning it.
I've created a script which runs through 1K pages and deletes content not needed (down to ~18 pages).
What I need to do now is add a conditional formatting script to the end to format words in the "Effectiveness" Table where if it finds:
"Weak" highlight table cell Orange,
Effective - Blue,
Not Applicable - Purple,
Adequate - Green.
Is there a script that can automatically format these words in the table cells?

Kind Regards,

Julian