Conditional formatting

[ozgur]

Hi everyone,

I need help to write an apparently simple excel function:

Let's say cell A1 has some text in it, and B1 has either the letter m or f. When I enter some text in column A, and enter m or f to cell B, I want excel change the color of the text in column A to red or blue, depending on whether I have m or f in the corresponding row of column B.

Should it be something like this (suppose I'm writing this to C1):

+IF(B1=="m", ???=blue, ???=red)

and ??? is something like "A1.font.color"? Or do I need something totally different?

I would appreciate any help.

Thank you in advance.

Ozgur

[mikerickson]

Conditional Formatting will do what you want

[ozgur]

Thanks a lot.