Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.1k views
in Technique[技术] by (71.8m points)

formatting - Is the date in the next 14 days or later

I have created a spreadsheet in Google Drive for my travel planning. In this table I would like to use conditional formatting. The field contains the date until which a free cancellation of the hotel is possible. I would like to change the font and the text color.

  • Case 1: I have more than 14 days until the date
  • Case 2: I have 14 days or less left
  • Case 3: it is the day or it is in the past.

I have tried, but my attempts have not resulted in any change to the font color.

Thanks for your help

question from:https://stackoverflow.com/questions/65873024/is-the-date-in-the-next-14-days-or-later

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

if A column holds your dates use custom formula in conditional formatting:

green:

=A1>TODAY()+14

yellow:

=(A1<TODAY()+14)*(A1>TODAY())

red:

=((A1=TODAY())+(A1<TODAY()))*(A1<>"")

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...