Forum Discussion

John_NumeroDos's avatar
John_NumeroDos
Copper Contributor
Mar 31, 2023
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...." ...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Mar 31, 2023

    John_NumeroDos 

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

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

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 31, 2023

John_NumeroDos 

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

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

 

  • John_NumeroDos's avatar
    John_NumeroDos
    Copper Contributor
    Apr 01, 2023

    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

Resources