Jim - Assuming you are trying to do this in CF and not Outlook - I'm Not exactly sure what yuo have setup - but it would seem that you just setup 3 shifts in a database. A,B,C - and in that table you would assign them a color.
Then you would have another table that links the Shifts to the Dates they are assigned. Then as you Loop through your calendar - or however you have it setup, you have each day look to the DB to find out what shift if any are assigned to it. You could streamline it by doing it all in one query beforehand too... And then have the color of the shift define the font color or background color - or whatever. That make sense? - Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2893 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
