Conditional Formatting

Sheets can automatically change the format of cells based on their contents.

    ➜ Try it
  1. Choose Format ⇒ Conditional Formatting.
  2. Apply the conditional formatting to range A4:A400.
  3. Format cells if Date is exact date =A$2.
  4. Choose how you want the highlighted cells to be formatted.
  5. At the bottom, click Add another rule.
  6. Repeat the above steps, this time applying to range B4:D400 and formatting the cells if Text is exactly =B$2.