Conditional formatting with AND function

[John_NumeroDos]

Hi there, 

I am trying to make a document with conditional formatting based on two variables:

a percentage value and a word (yes or no).

In conditional formatting I choose for "Use a formula...."

And then I use this formula:

="AND($C$15=""Yes"",$F$21<10%)"

This should be leading to a green cell. 

The formatting doesn't happen though.

Does anyone have an idea what I could be doing wrong here? 

Best regards,

John

[#2 · Accepted solution]

@John_NumeroDos 

=AND($C$15="Yes",$F$21<0.1)

You can try this formula if the format of cell F21 is percentage.

[#3]

@OliverScheurich 

It doesn't work, see below 😞

[#4]

@OliverScheurich 

Thanks for the suggestion. Excel tells me to add a ' if I don't want a formula and then changes it to

="'=AND($C$15='Yes',$F$21<10%)"

So, it doesnt accept the formula without the extra stuff.

Any idea why this happens? Drives me crazy

[#5]

@OliverScheurich 

I got it, I used a , instead of ;