Hi,
How can I highlight (or just change the color) the text which have changed in a formula cell. All the cells i need to highlight are in columns (D,E,F).
Because the formula in the cell never change, just the text in the cell and i don't know how to do it, cause i can't refer to the value in the cell, she remains the same (=INDEX(Sheet1!R:R;MATCH(A9;Sheet1!D:D;0)))...
Thanks for helping me![]()
Bookmarks