Code to change cell color based on value

[UFGATORS]

I currently have a spreadsheet that I use conditional formating to change a cells color based on the value entered in the cell. My problem is that sometimes the conditional formating does not work properly. I'm assuming a code could be developed to do this task. If someone could help with this I would appreciate it. Following are the particulars
The range that the codes are entered in is G3:AK252
I would like for the cell to turn red for thefollowing codes (AL+, SAL,SSL,MC,DCD,DCS, and SL), Blue for codes (AL and BH) and Green for codes (EAL, EAL/AL,EAL/SSL,EAL/BH,ESL,ESL/BH,ESL/MC, ESL/AL, NA, NA/SSL, NA/DC, A/DCD, and ASC).

Thanks, Steve

 

[AlphaFrog]

Select cells G3:AK252

Condition 1
Formula is =ISNUMBER(SEARCH("|" & TRIM(G3) & "|", "|AL+|SAL|SSL|MC|DCD|DCS|SL|"))
Format Red

Condition 2
Formula is =OR(TRIM(G3)="AL",TRIM(G3)="BH")
Format Blue

Condition 3
Formula is =ISNUMBER(SEARCH("|" & TRIM(G3) & "|", "|EAL| EAL/AL|EAL/SSL|EAL/BH|ESL|ESL/BH|ESL/MC|ESL/AL|NA|NA/SSL|NA/DC|A/DCD|ASC|"))
Format Green

 

[UFGATORS]

Sorry for my ignorance, but how do I enter the code. I tried pasting it into a module in VBA and that did not work.

 

[AlphaFrog]

They are conditional formatting formulas and not VBA code.

 

[UFGATORS]

Got it, they work fine. If it is not to much to ask, could you explain what the different elements of the formula are doing or asking. I would really like to learn how do to this. Thanks

 

[AlphaFrog]

TRIM function

SEARCH function

ISNUMBER function