How would I do this please?

[magiciansmask]

Is there a way to automate a spreadsheet where the date activates other cells? For example, if I put in the date manually, it would say open up text in another row? Say A1 Date opens up text in B1

 

[GraH]

Hello, not sure what you are after, but a simple if might do it, or conditional formatting.

Book1
	A	B
1	1/08/2020	Date opens up
2		Date opens up
3	2/08/2020	Date opens up
4
5
Sheet1

Cell Formulas
Range	Formula
B3	B3	=IF(A3,"Date opens up","")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B2	Expression	=$A1=""	text	NO