Conditional formatting with AND operator

[JoepDemey]

Hello,

I have a simple request, and I thought I had the answer myself, but I must be doing something wrong....

I am using Excel 2007 and I have a sheet with 3 columns:
- Column A contains either "ja" or "nee" (yes or no in dutch)
- Column B contains numerical values
- Column C should have a conditional format of a certain color fill, when:
A is "ja" AND B > 100

I have put a conditional format on column A with the formula

Formula: =A1="ja"

I have put a conditional format on column B with the formula

Formula: =B1>100

But I can't get my conditional format on column C with this formula

Formula: =AND(A1="ja",B1>100)

I get this error:

The formula you typed contains an error.

• For information about fixing common formula problems, click Help.
• To get assistance in entering a function, click Function Wizard (Formulas tab, Function Library group).
• If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (').

 

[Ahonymus]

The same for me. I have been at war with that topic for a while and the answer had been waiting here for years... Thanks for the OP and all those who answered.