I need this conditional formatting formula

Question

Basically I want to write a conditional formatting equation on Google Sheets that will check if a formula is being executed consectveiy down a column? e.g. in column D I have the following equation from rows 4-10 =concatanate(A4&""&B4&""&C4) and this is applied to row 10.

I want to write a conditional formatting that checks that at every row the cells are referencing the row it's in. So at row 8 it should be A8&""&B8&""&C8. I want to know if it's not consecutive down the column if that makes sense so if at row 8 it's A9&""&B9&""&C9 instead then I want it to highlight red.

$A4 & "" & $B4 & "" & $C4

Answer 1

Apply to range: D4:D10

Custom formula is:

=--regexextract(formulatext(D4),"\d+")<>row()

Scenario 2:

to check if output by formula in column_E is matching with what it ideally should've been for that specific row → if NOT → highlight

=len($E2)*($E2<>"https"&join("_",offset(indirect("A"&row()),,,,3)))