Try this:

Select cell A1
Goto the menu FormatConditional Formatting
Condition 1
Formula Is: =A1="x"
Click the format button
Select the style(s) desired
OK
Click the Add button
Condition 2
Formula Is: =A1="y"
Click the format button
Select the style(s) desired
OK out

Biff

"SPM" wrote in message
...
version 2000


"T. Valko" wrote:

What version of Excel are you using?

Biff

"SPM" wrote in message
...
Suppose Cell A1 = x, then I want to color B1 black
& when Cell A1 = y, then I want to color B1 blue