Conditional Formatting For Multiple Strings of Text in One Cell

[mongoruth]

I'd like to use conditional formatting to shade a cell that contains, for example, "G8 Math 2". If it says, "G8 Math 3", I'd like it to be a different color. And, if it says, "G6 Math 2", yet another color. Some of my cells also contain additional text, such as a co-teacher's initials, and I want the rule to ignore any additional text in the cell. Basically, I want it to highlight different for each grade, and each class. There are three grades (G6, G7, G8), and four classes (1, 2, 3, 4). But also within a given cell would be the subject name and potentially other text.

Is this possible?

Thank you!

 

[Fluff]

How about
=AND(ISNUMBER(SEARCH("G8",J4)),ISNUMBER(SEARCH("1",J4)))

Change the J4 to match the first cell in the applies to range

 

[mongoruth]

Yes!! Thank you so much! That worked perfectly

 

[Fluff]

You're welcome & thanks for the feedback