Zend certified PHP/Magento developer

“Structured references” work in equation, but same equation doesn’t work in “structured references”

I have this formula with “structured references”:

=ISNUMBER(SEARCH(Table10[[#Data],[Process1]:[Process18]] & "_" & RIGHT(Table10[[#Headers],[Process1]:[Process18]],LEN(Table10[[#Headers],[Process1]:[Process18]])-7),Table10[[#Data],['#Experiment processes]]))

which works great if I input it in any cell… But If I try to use it with Excel’s “conditional formatting” it doesn’t work! I get this error:

enter image description here

I found this post but I don’t understand how to apply the described solution in my case. I would kindly ask you toe be descriptive, i.e. explain why do we use something etc…