Question

On the Exhibitors worksheet, what conditional formatting rule should be added to the Exhibitor Name column for the specified conditions?

a) Yellow fill if Industry is Clothing
b) Gray pattern if Booth Size is more than $1,000
c) Yellow fill with Gray pattern if Industry is Clothing and Booth Size is more than $1,000
d) No conditional formatting needed for the specified conditions

Answer 1

The conditional formatting rules for the Exhibitor Name column are as follows: yellow fill if Industry is Clothing, gray pattern if Booth Size is more than $1,000, and yellow fill with gray pattern if Industry is Clothing and Booth Size is more than $1,000.

Step-by-step explanation:

The Exhibitor Name column on the Exhibitors worksheet should have a yellow fill as a conditional formatting rule if the Industry is Clothing. This will visually highlight the exhibitors in the clothing industry.

If the Booth Size is more than $1,000, the conditional formatting rule should be a gray pattern for the Exhibitor Name column. This will make it easier to identify exhibitors with larger booth sizes.

If both conditions are met, meaning Industry is Clothing and Booth Size is more than $1,000, the conditional formatting rule for the Exhibitor Name column should include a yellow fill with a gray pattern. This combination will indicate exhibitors in the clothing industry with larger booth sizes.

No conditional formatting rule is needed for the specified conditions means that there will be no formatting applied to the Exhibitor Name column based on the conditions provided.