Hi everybody..

I need your help to solve a little issue

i got two sheets on the sheet1 a table where is a column that refer to others value on a the sheet2.

=INDEX(Sheet1!R:R;MATCH(A9;Sheet1!D:D;0))

When i change the value in a cell on the sheet 2 the value in the cell on the sheet1 change as well. That's ok, but i need to highlight the cells which have changed on sheet1 (the cells refered from sheet2) but i can't do it cause the text is changing but the highlighting refers to formula bar and it remains the same : =INDEX(Sheet1!R:R;MATCH(A9;Sheet1!D:D;0))

Thanks for help and advice