Is there a reason why the values are text?

The first four are pretty straightforward setting formats for a single cell if it happens to equal a certain value. Do you know how to do that? The trick here will be to make sure it is looking for the text (e.g. "99") rather than the number.

The next two are a bit trickier, but can be done. I have done it on your sheet and will post it a bit later if you want. For these, you need to use a formula. For example, when you are checking if the os a Code 3, but no Code 2 or no Code 1, it would be something like:

=AND(isblank(S9)=FALSE,OR(ISBLANK(Q9),ISBLANK(O9)) )

The first part would be a bit simpler, S9>0, if the values were numbers instead of text. Another way to get around the text would be VALUE(S9)>0. Lots of ways to skin that cat.

I've only briefly looked at the remaining, but can't see any reason why they can't be done as well. I am heading into a meeting soon but can post it later if you like.