I am looking for a way to apply conditional formatting to a column in Excel such that each time a certain text string is found it highlights the cell exactly 60 rows below it.
For example if Rows 1 & 20 have the text "Buy" then rows 61 & 80 should be highlighted in Green.
It needs to count cells even if they are blank