Colour Code a cell with wording matching the colour based on Data across Excel Spread Sheet

KilJhard 

I hope I can explain this correctly
cause I'm still trying to understand
in my head
what I'm attempting to do!

That's not an encouraging start. Perhaps the most important step in getting Excel to do what you want it to is to be able to put that desire into words, clear words. This may be why, after some 60 views, you've still had no response.

I hope this makes sense but

if it's confusing please let me know

and I'll create a diagram to [illustrate] what I'm trying to do.

Better yet, create a spreadsheet--you may already have it--with the data (or a mockup that accurately represents the data, if the real stuff is confidential)--and an example or two of what you're trying to do. Images alone aren't anywhere close to as helpful as an actual spreadsheet. Post it on OneDrive or GoogleDrive and paste a link here that grants access.