If I can figure out how to do it, I would prefer to build the array
from a "legend" on a separate worksheet named "Legend". Each approved
day code, like "ML" or "08", would be on the legend with its color and
font scheme. The VB code for the worksheet would look at the legend to
determine if a typed day code was approved and would colorize the cell
according to the legend. That way, if additional day codes are needed
later, or we decide to change the color scheme for certain codes,
simply changing it in the legend will accomplish the task without
having to change any VB code. I hope to add a sheet called "legend"
with the column 1 being the colorized day code and column 2 being the
text explanation for its use, like "SL" means "Sick Leave".