Don't want to be an ass, but... I can't tell the weapon tiers. Colorblind as fuck, sorry! Excellent work, tho. I do enjoy reading the guide. Everyday I learn something new, or recheck something.
Edit: Maybe an extra column with the Tier?
That's fair enough. My one old gaming buddy sees both red and green as blackish so always said to me for most circumstances it's fine as long as red and green are not "adjacent" tiers, but I guess that is only the one type of colour-blindness.
I have used filled in box conditional formatting symbols before to help one other chap (i.e little box with four segments) but for some reason, those always get removed on Google Sheets which is notoriously bad for conditional formatting compared to Excel (I make these on Excel and then upload them to the drive).
Glad you're enjoying it, that's the main thing!
The tier's are all kind of subjective in any case and you can usually come to the conclusions yourself with the descriptions.