I need to compare some cells in my table but I need to select more columns so its little bit tricky. Here is my table:
I need to check if in columns E, G, J, L, O, Q, T, V some number matches number in column A. If yes, then highlight that number in A column with red number.
I tried to create formula with conditional formatting but this not works.
I will be happy for any help.