Sometimes the Built-In Conditional Formatting Rules Do Not Apply the Formatting

question 91

Essay

Sometimes the built-in conditional formatting rules do not apply the formatting you need.In these instances,you may be able to create a conditional formatting rule based on a formula that uses a logical expression to describe the condition you want.Please give an example of when you would use this type of formula,and list two guidelines you must follow when creating this type of formula.

---

Definitions:

Tenth Year-end Deposit

The act of placing funds into a financial account or investment at the end of the tenth year of the account or investment's existence.

Annual Year-end Payments

Payments made at the end of a fiscal year, often related to taxes, dividends, or bonuses.

Interest Rate

The percentage of a sum of money charged for its use, often expressed annually.

Annual Rate

A percentage representing the interest, return, or changes expected over a one-year period for investments, loans, or growth calculations.