Query to match the formatting across tabs

Hi, may be a simple fix for this (i’m quite an excel noobie) but can’t seem to work it out.

so, on Tab A I’ve got 16 unique words on the tab. I’ve personally gone through and given each word its own formatting (basically just a different background colour for each)

Now, on tab 2, these same words (exact same) appear multiple times each in random orders across 5 rows and over a hundred columns

What i want to do is just be able to make it so that this tab matches the formatting form tab A

so, for example Tab A has the word “Succesful” which i’ve put in Green. How can i make it so every time Succesful appears in Tab B it is also green, and then repeat this for all 16 words

thanks for any help