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.
