When cell with formula changes -> edit adjacent cell

[Dani_LobP]

Hi all,

I want to know if its possible the below scenario:

I have a table, with some formulas here and there, but in column O, I have a formula with some conditions and dependent on other 3 columns in same table.
What I want to know, is, if I can have some kind of script that every time formula in O is refreshed and the result changes, to have in column P a Yes, and if nothing changed, leave it with No (as per default).

So basically I want to just have a Yes in P column, when the formula in O result changed (because other columns values were edited, making O formula bring different result).
O column cell formula starts in O6 , same as P columns, is P6 if that helps.

I tried to check around but some answers can't really fully understand.

By the way, is this a potential reason to make file slow? and, if formulas are set to manual, will macro only work once refresh happens?

thanks in advance!

 

[Dani_LobP]

Comment out the Exit For line

        If arr(i, 1) <> arrTemp(i, 1) Then
            Sheets("BSS Template").ListObjects("MainData").ListColumns("BSS input").DataBodyRange.Cells(i).Offset(, 1) = "YES"
            Exit For    ' to not check any further
        End If

Oh ok, i actually saw that, but wasnt sure what it meant. So that comment prevented it from checking the whole table line by line?
without comment, will just check all the way down ?

 

[Dani_LobP]

Comment out the Exit For line

        If arr(i, 1) <> arrTemp(i, 1) Then
            Sheets("BSS Template").ListObjects("MainData").ListColumns("BSS input").DataBodyRange.Cells(i).Offset(, 1) = "YES"
            Exit For    ' to not check any further
        End If

edit:
thanks!
so by commenting it out, will be checking the whole table from top to bottom vs checking until 1 YES happened, right? seems to work now after testing a bit.
somehow makes the file slow when formulas are set to automatic, so will have to keep them manual and refresh every now and then.

thanks again for your help!