For conditional formatting a formula must be in the form of a ____ text that results in a true or false value.

Question

Quizplus · Accepted Answer

The formula used for conditional formatting must be a logical text that evaluates to either true or false. This text can use simple or complex logical operators such as "AND", "OR", "NOT", or "IF" to make the evaluation. Examples of logical formulas include "=$A$1>10", "=$B$2=0", or "=AND($C$3>5,$D$3<10)".

For Conditional Formatting a Formula Must Be in the Form