What is not true about using the AND function in a custom conditional formatting rule?
A)All the tests must be of the same data type, for example: all numbers or all text.
B)All the logical tests must be true for the formatting to be applied.
C)You must have at least two tests in the formula.
D)You may have as many tests as you need in the formula.

Question

Quizplus · Accepted Answer

The AND function can work with different data types, so this statement is not true.

Answer: B 
 This is true, all tests must be true for the formatting to be applied.

Answer: C 
 This is also true, you must have at least two tests in the formula for the AND function to work.

Answer: D 
 This is also true, you may have as many tests as necessary in the formula.

What Is Not True About Using the AND Function in a Custom