You work as a Sales Manager for Peach Tree Inc. Your responsibility includes creating sales reports of
the company. You create a report in a workbook in Excel 2010. The report contains a worksheet that
has been formatted by using the conditional formatting feature. You have specified five conditions
for conditional formatting of a list appearing in the sheet. You save the report and send it to your
manager. He informs you that the sheet on which conditional formatting feature is applied is not
appearing according to his requirement. He further specifies that only a few of the conditions are
applying. What is the most likely cause?
A.
You have not saved the Excel workbook in .xlsm format.
B.
The manager is using Excel 2003 or earlier version of Excel.
C.
Some of the conditions are cross referencing in the specified conditional format conditions.
D.
Specified rules are conflicting.
Explanation:
According to the question, your manager is unable to see the formatting required. The question also
specifies that only a few of the conditions are applying. The most likely cause of the issue is that he is
using a previous version of Excel. The question clearly states that you have specified five conditions
for conditional formatting of a list in the sheet. Conditional Formatting feature of Excel 2007 and
2010 supports up to sixty-four conditions; whereas, the earlier versions of Excel support only three
conditions. In earlier versions of Excel, users will see the first three conditions only. All conditional
formatting rules remain available in the workbook, however, they are applied when the workbook is
opened again in Excel 2007/2010, unless the rules are edited in the earlier versions of Excel.