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

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.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.