highlighter 4 consecutive

[alexandru barabas]

hello, can someone please help me solving this?

i am trying to highlight 4 cells starting with the cell that contains the word "da". i tried to make it from the conditional formating tools but it only highlight the cell that contains the cell with that text. i attached 2 pictures for a better understanding, one is how it is with conditional cormating rool and the othes is how i would like to be

thank you in advance

 

[pecoflyer]

Hi and welcome. Please post your sheet. Pics are useless. Thx

 

[p45cal]

See the conditional formatting in the attached for cells E3:O16
Slightly different CF for cells B3:D16.

 

[alexandru barabas]

Hi and welcome. Please post your sheet. Pics are useless. Thx

hi , sorry didn't know . tnx

 

[Peter Bartholomew]

See the conditional formatting in the attached for cells E3:O16
Slightly different CF for cells B3:D16.
View attachment 86173

Nice! Well spotted on the wrapping problem.
My attempt to create one condition was something of a nuclear option when simply used to drive a conditional format.

= TestPriorCellsλ(count, string)

=OR(
    MAP(
        SEQUENCE(1, n, 0, -1),
        LAMBDA(k, LET(
            testCell, OFFSET(currentCell, 0, k),
            IFERROR(testCell = string, FALSE))
        )
    )
)

The values to the right define the block length and the key values to be highlighted.