Strikethrough previous rows

[Nene614]

Is there a formula I can use that if I enter a date in a cell in Column G that rows a-g can be formatted with a strikethrough. For example:

A has number-number; B has text; C has text; D has text; E has text; F has a date (24-10); and G has 14-Nov-23 and once the date in G has been entered, I want A-G to have the strikethrough.

 

[awoohaw]

If you want to consider DATE in G as a Number:
(you could add some date ranges in the formula to make the rule more accurate).

Mr Excel Questions 72.xlsm
	A	B	C	D	E	F	G
1
2	458409	dkakldjf	dkf	dfd	faf	2023-01-04	2023-01-05
3
Nene614

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:F2	Expression	=ISNUMBER($G2)	text	NO

The xl2bb didn't copy the text formatting there: