change fill color of a range of cells based on color of a cell?

I want to change the color of a range of cells based on the color of a
different cell. How do I do this. I tried conditional formatting but this
only lets me specify the color in the conditional formatting box. It does
not allow me to point that to a cell and a color reference.

For example - cell A1 is red - change cells A5-A8 to red. Cell B1 is green
- change cells B2-B11 green etc..

Use a formula in the conditional formatting:
Example
(condition)$a$1=1
(condition)$a$2=2

If you're not using conditional formatting then maybe:

Please Login or Register  to view this content.

@maward00 - Why are we replying too a thread dated March 2, 2006??