Conditional formatting

[Cquake]

I am pulling data from a vlookup function which does allow me to pull the color formatting. With that being said I have positive results which are in green, negative results in red, a QT entry also in red, a QR in white, 0 (zeros) in white and PEN with a plus sign and number. The data will change for each team pulled up.

when I pull that data from the vlookup into the cells is there a way to use conditional formatting to accomplish color coding them? Any help would be appreciated. There are 3 seperate team data areasthat have 39 rows down and 9colums across.
Team data area are named offense, defense and special teams

 

[Joe4]

Excel functions (such as VLOOKUP) can only return values, not any formatting from the source field.
However, you can set up the same Conditional Formatting logic that is applied to the original data so that what is returned matches the format of the original data.