Adding Color to figures within the result of a formula

[LGMan]

Hi carrying on from a thread that I started on the Microsoft Office forum hoping CFs might help.

I have a formula that pulls data from a table such as a Team Name and a result figure in order of high to low results, I would like to colour code the result figure so that results greater than or equal to 95% are green and results less than 95% are red.
here is my formula in cell F6

=VLOOKUP(1,A610,2,0)&" ("&TEXT(VLOOKUP(1,A610,4,0),"0.00")&"%), "&VLOOKUP(2,A610,2,0)&" ("&TEXT(VLOOKUP(2,A610,4,0),"0.00")&"%), "&VLOOKUP(3,A610,2,0)&" ("&TEXT(VLOOKUP(3,A610,4,0),"0.00")&"%), "&VLOOKUP(4,A610,2,0)&" ("&TEXT(VLOOKUP(4,A610,4,0),"0.00")&"%) & "&VLOOKUP(5,A610,2,0)&" ("&TEXT(VLOOKUP(5,A610,4,0),"0.00")&"%) "
So the result looks like this

North ([green]96.00%[/green]), South ([green]95.00%[/green]), West ([red]94.00%[/red]), North ([red]93.00%[/red]) & Central ([red]92.00%[/red])

The table consists of Team Names in B6:B10 and Results in D610. A6:A10 contains a Rank high to low, from 1 to 5.

Is there a way to add the color coding via VBA. If it's not possible to apply colors to the formula in F6, then I could easily copy and paste as values into G6, if applying color is more straight forward to a text string.

Thanks

 

[SkipVought]

Hi,

This is not forum707 as previously advised.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]