Gloria,
I think what Marcia Akins and Gregory adam gived U, had solve the problem
U just need to combine them both...
OK...
<b>
Simple add IIF() in DynamicForecolor or DynamicBackColor...
</b>
Nice to C U in this thread...
Sorry if i couldn't fulfill you need..
ok...
thanks
regards
tutarie
The More We give, the more we earn