Forum Discussion
Solved
Conditional formatting with AND function
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
=AND($C$15="Yes",$F$21<0.1)You can try this formula if the format of cell F21 is percentage.
=AND($C$15="Yes",$F$21<0.1)You can try this formula if the format of cell F21 is percentage.
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
