Hi All

I am trying to use conditional formatting to change colors of cells for
scheduling purposes. There are a large amount (20) of criteria that could
make a cell one of three colors (representing work shifts). Each criteria
represents a work center and hours of work, ie 1-8, workstation 1 for 8
hours. The cell will look like this,1-8 (1), work center 1, 8 hours, on
shift 1. I need Excel to recognize the 1 and assign a corresponding color.
If anyone could offer any assistance on the formula or formula setup, I would
greatly appreciate it.