Conditional Formatting in Google Sheets

The video tutorial introduces new conditional formatting options in Google Sheets, focusing on gradient color scales and style choices like bolding and striking through text. It demonstrates how to apply these features to analyze stock prices and flight costs, offering insights into trends and optimal times for travel. The tutorial also covers customizing color scales and using advanced formatting techniques to highlight specific data points.

What new feature allows you to apply a gradient of colors in Google Sheets?

• Single color formatting

• Gradient conditional formatting

• Pivot tables

• Data validation

Which style choice is NOT mentioned as part of the new conditional formatting options?

• Striking through

• Underlining

• Italicizing

• Bolding

What is the purpose of using color scales on stock prices in Google Sheets?

• To sort the data

• To visualize highs and lows

• To create charts

• To calculate averages

What can you adjust when customizing a color scale in Google Sheets?

• Sheet name

• Minimum and maximum values

• Cell borders

• Font size

Which color combination is NOT mentioned as an option for color scales?

• Dark Yellow to Cyan to Red

• Green to Yellow to Red

• Green to White to Red

• Blue to Yellow to Green

How can you quickly identify the best days to fly using conditional formatting?

• By using a pivot table

• By filtering the data

• By using a color scale

• By sorting the data

What color indicates the best value for flight prices in the example?

• Dark green

• Blue

• Red

• Yellow

What formatting option is used to highlight values greater than $100?

• Striking through

• Bolding

• Italicizing

• Underlining

What happens to values greater than $100 in the flight data example?

• They are moved to a new sheet

• They are struck through

• They are deleted

• They are highlighted in red

Which of the following is NOT a style choice available in the new conditional formatting options?

• Bolding

• Italicizing

• Striking through

• Underlining