CODEWITHSUNDEEP
google-sheetsspreadsheet
Sem Roijackers
Sem Roijackers

Reputation: 3

How can i change text depending on the date in another cell Spreadsheets

I am trying to make a cell change its text depending on another cell whit a date. example how i would like the text to change

So basicly if there is one week past from today the text green needs to change in the text red. Is this possible? If so how beacuse im lost.

Error

Upvotes: 0

Views: 2022

Answers (1)

Alessandro
Alessandro

Reputation: 2998

Edit text

  1. Be sure that the cell value is formatted as Date (Format>Number>Date)
  2. Put this formula in column A and drag it down to match your dates:
=IF(B2<TODAY()-6, "Red", "Green")

Edit background color

  1. Be sure that the cell value is formatted as Date (Format>Number>Date)
  2. Create a Conditional formatting rule (Right-click>Conditional Formatting) with these parameters:

Format cells if...

  • Date is before
  • Exact date
  • =TODAY()-6

Formatting style

  • Put desired background color

Reference

Conditional Formatting

Upvotes: 1

Related Questions