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

I've been able to piece together the following formula based on web searches, and I'm close to an answer.

Here is what I want to do:
An end cell has conditional formatting to color the cell red, green, or yellow when R, G, or Y respectively are in any of the preceding cells according to a heierarchy Where G trumps all, Y trumps, R, or blank if nothing. i.e. if all the previous cells in the row contain a Y then the end cell automatically populates a Y. But if any of the Cells contain a G then the last cell takes on a G value. Or if all are R except for 1 Y then the final cell populates as Y.

=IF(ISNUMBER(SEARCH("G",N8)),"G",IF(ISNUMBER(SEARCH("Y",N8)),"Y",IF(ISNUMBER(SEARCH("R",N8)),"R"," ")))

This works for a single cell N8. When I try to increase to a range to be N8:S8 The final cell in the row goes blank defaulting to my lowest level value.

How do I get this formula to work with a series of cells instead of just a single cell?

I got a #VLUE! for that one. I don't understand where that formula is searching each cell for one of the 3 options. Can you explain that formula to me and maybe I'll see where it can work?

It works better than mine for all the rows. But in the case where some cells are not filled in yet it defaults to the G which is the highest level answer. I would like it to default to the highest in the row even if some cells are blank. I guess I didn't include that scenario.
For instance where "-" = blank cell

N8 O8 P8 Q8 R8 S8 T8
- - G Y R R G
- - Y Y - - Y
- - - - R R R

I only get blank in the last cell no matter what I put in the others. Will you help me to understand what that formula is supposed to be doing?

BTW Ron, thank you for your help. I appreciate you working through this with me.

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.

Awesome!! That works great. Exactly what I was looking for! Thanks so much for your help Ron.