Set a text value of a cell if a series of cells contains any specific text string

Ron,

Here is a sample of one row with the formatting. https://db.tt/qqPhSNa6
I have my original formula in cell T8. So if you change the status of Cell N8 it will change the status of T8 and format accordingly. That is the way I would like it to function for all 6 cells simultaneously, with the hierarchy in place of G then Y then R, and blank if all cells are blank. There may be some cells which are N/A which should be ignored.

Thanks for your help. I look forward to seeing what you come up with.