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.

1 Answer 1


Please select A26:B124 and apply a Custom formula is of:


with the addition of further countifs to suit you and your choice of formatting.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.