i have a vlookup formula as follows:

=IF(ISNA(VLOOKUP($A56,'2006 Top
40'!$A$8:$B$470,2,FALSE)),IF(ISERROR(VLOOKUP($A56, '2006 All
Clients'!$A$7:$B$4482,2,FALSE)),"0",(VLOOKUP($A56, '2006 All
Clients'!$A$7:$B$4482,2,FALSE))),(VLOOKUP($A56,'20 06 Top
40'!$A$8:$B518,2,FALSE)))

Now - i would like to add conditional formatting so that if the result came
from the middle vlookup - the font color would be different - is this
possible?