1. I have a workbook with data that is linked from other workbooks. In this
final one I have linked the color score (e.g. RED, BLUE, GREEN, YELLOW) which
appears with a background of white. I need the background to appear in the
color that is linked but conditional formatting permits only 3 conditions.
How do I apply the 4th condition.

2. In addition, I have a workbook that based on dates and % complete there
is an adjacent cell that is a color coded score.

For instance: Cell A1=Sep-05, A2-Sep-30, Cell f2=0% = Result in the case for
cell g2 would be green since this task has started.
If I had A3=Aug-8, A3=Sep-30, cell f3=0% = result in cell g2 should be RED
since it has not started.
Again this is more than 4 conditions and I need the g cells to reflect a
color.

Any assistance on either problem will be appreciated.

Sue