In conditional formatting,to highlight only cells that contain a specific date,select the rule _____.
A)A Date Occurring
B)Duplicate Values
C)Text That Contains
D)Equal To

Question

Quizplus · Accepted Answer

The best choice to highlight only cells that contain a specific date is to select the rule "A Date Occurring". This rule allows users to format cells that contain dates matching specific criteria. This rule is ideal because it will only highlight cells that contain a specific date, whereas other rules such as "Equal To" may also highlight cells that contain text or other values that match the criteria.

In Conditional Formatting,to Highlight Only Cells That Contain a Specific