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.

Question

Quizplus · Accepted Answer

The Answer of 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.

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