>Jim,
>
>Thanks for the reply and we're on the right track. I'd like to narrow the "red cells" to include only those cells that are negative. Right now the code changes the forecolor of the entire row in all columns. Ideally those cells which are positive are black and negative cells are red.
>
>Thanks in Advance.
>
>Scott
Use the Column.DynamicBackColor of the columns you would like to highlight in red:
DYNAMICBACKCOLOR = IIF(tablename.field < 0, RGB(255,0,0), RGB(255,255,255))
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site