I believe that this will work but is there a way to program it into the conditional formatting instead of setting it up as a function tied to a cell? I am creating a template that will be used monthly with different data.
I messed around with the formula a bit because I wasn't able to make it work at first for my document. However now when I try to use it, it will only work for items that are tier 3. Do you see something that I did wrong?