You need only one condition for each cell if I read your decription
properly.

A4 condition would be =B4=4 format as red

A5 condition would be =B5=5 format as blue


Gord Dibben MS Excel MVP

On Fri, 12 Sep 2008 07:31:01 -0700, Tee
wrote:

I have a row of 21 cells in column A. I have a row of 21 cells in column B.

I want column A4 to change text color based upon number entry into B4.

For instance, if I enter the number 1 into B4, I would like cell A4 text to
change to red.

For instance, if I enter the number 2 into B5, I would like cell A5 text to
change to blue.

I can't use conditional formatting b/c it only gives me up to three
conditions. I need 21 conditions.

Thanks in advance for your help!

Tee