Coloring empty sites for holidays and site type

A previous article covered how to color-code the date column headings and also the empty sites for special dates like holidays.  That article used a sample custom color scheme that you can import and modify.  The article can be reviewed here:

http://campgroundmaster.com/news/coloringtherackdatesforho.html

Note:  The sample file used in the example above had a couple mistakes.  The "Default scheme" selection should be "Open Sites (Rack)" rather then "Reservations".  Also, the rules in the sample did not check for the "unavailable" status, which is shown below.

Now if you want to also use different colors for different site types, that's quite simple to do.

Starting with the example above, the expression for a rule for a simple holiday weekend color might be:

ColorStatusSite(ThisSite(), ThisDate(), ThisPeriod()) != 9 AND (ThisDate() = {7/2/2010} OR ThisDate() = {7/3/2010} OR ThisDate() = {7/4/2010})

Note that the ColorStatusSite( ) check is to make sure we don't include "Unavailable" sites in the new color rule.

Now if you want to only change the color for a certain Site Types, just add a site type check in front:

Site:Attrib_Site_Type = "Room" AND ColorStatusSite(ThisSite(), ThisDate(), ThisPeriod()) != 9 AND (ThisDate() = {7/2/2010} OR ThisDate() = {7/3/2010} OR ThisDate() = {7/4/2010})

Those are the basics.  See the article mentioned above for more details, and remember to select your new color scheme for "Override empty Sites..."  under Advanced Customizations / Select Global Color Schemes.