Select A2:L2

FormatConditional FormattingCondition1Formula is:

=$A$2=1

Format to blue pattern.

AddCondition2Formula is:

=$A$2=2

Format to orange.

The $ signs are mandatory to lock A2 as the trigger cell.


Gord Dibben MS Excel MVP

On Tue, 10 Oct 2006 10:21:01 -0700, Saleee
wrote:

How can I change font color of a whole row if, say, cell A2 =1?
e.g
IF cell A2 = 1, then make range A2:L2 blue
IF cell A2 = 2, then make range A2:L2 orange
etc.