Sheets can automatically change the format of cells based on their contents.
➜ Try it
- Choose Format ⇒ Conditional Formatting.
- Apply the conditional formatting to range A4:A400.
- Format cells if Date is exact date =A$2.
- Choose how you want the highlighted cells to be formatted.
- At the bottom, click Add another rule.
- Repeat the above steps, this time applying to range B4:D400 and formatting the cells if Text is exactly =B$2.