Recall & Review

beginner

What is date-based formatting in Google Sheets?

Date-based formatting changes the look of cells depending on the date values they contain. For example, you can color cells red if the date is past today.

Click to reveal answer

beginner

Which formula would you use to highlight dates before today?

Use the formula =A1<TODAY() in conditional formatting to highlight dates before today.

Click to reveal answer

beginner

How do you apply conditional formatting based on dates in Google Sheets?

Select the cells, go to Format > Conditional formatting, choose 'Custom formula is', enter a date formula like =A1>=TODAY(), then pick a format style.

Click to reveal answer

intermediate

What does the formula =AND(A1>=TODAY(), A1<=TODAY()+7) do in date-based formatting?

It highlights dates in cell A1 that are within the next 7 days, including today.

Click to reveal answer

beginner

Why use TODAY() instead of a fixed date in date-based formatting?

TODAY() updates automatically every day, so your formatting changes as time passes without needing manual updates.

Click to reveal answer

Which formula highlights dates that are exactly today?

A=A1=TODAY()

B=A1<TODAY()

C=A1>TODAY()

D=A1<=TODAY()

How do you open the conditional formatting menu in Google Sheets?

ATools > Conditional formatting

BData > Conditional formatting

CFormat > Conditional formatting

DInsert > Conditional formatting

What does the formula =A1>TODAY()+30 highlight?

ADates within the next 30 days

BDates in the past 30 days

CDates exactly 30 days ago

DDates more than 30 days in the future

Which function returns the current date in Google Sheets?

ANOW()

BTODAY()

CDATE()

DCURRENTDATE()

To highlight past due dates, which formula is correct?

A=A1<TODAY()

B=A1>=TODAY()

C=A1=TODAY()

D=A1>TODAY()

Explain how to set up conditional formatting to highlight dates within the next week.

Why is using the TODAY() function helpful in date-based formatting?