>Thanks, Koen, I will certainly look at it. I noticed it only has a choice of 2 colors presently with the IIF() function, but perhaps if I use the ICASE() I will be able to get it to work with more. Here is a pic of what I have so far...seems to be working well. Now just a timer to get it to refresh at an interval. It reflects changes in job status for the day as techs handle tickets on their tablets on the road...

John,
no problem, just implent an icase() and you can maken n Colorcombinations.
A timer? With a grid it can be refreshed by just refreshing the data, no data change no need to refresh.
Regards,
Koen