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($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