Excel using cell color to select data from another spreadsheet

I have a calendar built in excel and are using conditional formating to change the color of a cell using a separate spreadsheet to determine which cells to color.   The calendar worksheet is calcul...