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

question 14

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.

---

Definitions:

Mid-1980s

A period marked by significant cultural, political, and technological changes globally, roughly encompassing the years from 1983 to 1987.

AFL-CIO Merger

The unification in 1955 of the American Federation of Labor (AFL) and the Congress of Industrial Organizations (CIO), creating the largest federation of unions in the United States.

Industrial Unions

Labor unions that organize workers across entire industries, rather than by craft or trade, to collectively bargain for better terms of employment.

Craft Unions

Unions composed of workers specialized in a particular craft or trade, focusing on specific job skills and worker rights within that profession.