I'm trying to change the color of my result to a different color based on
which answer a formula brings back. all my answers are in text format. The
formula is below which is just a simple vlookup data proving type.

=IF(ISERROR(IF(C7="DDG",VLOOKUP(B7,'DDG
Cars'!$A$2:$B$152,2,FALSE),VLOOKUP(B7,'Ethanol
Cars'!$A$3:$C$499,3,FALSE)))=TRUE,"",(IF(C7="DDG", VLOOKUP(B7,'DDG
Cars'!$A$2:$B$152,2,FALSE),VLOOKUP(B7,'Ethanol Cars'!$A$3:$C$499,3,FALSE))))