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