Conditional Formatting in pairs

[komhs]

Hi to all and thanks in advance for your help

I have a Data set in columns which is in pairs.

I have created a conditional formatting for the first pair in this data set, but I don't know how to make this condition to apply and for the rest pairs

Can you help me on this please?
Book1.xlsx

[WideBoyDixon]

Highlight A2:A39, create a new conditional format based on a formula and use this formula:

Please Login or Register  to view this content.

See attached.

WBD

[komhs]

Thank you so much. It works! Before I mark the issue solved may I ask you something similar? If the pair was horizontal I would have used the same formula?

[HansDouwe]

If the pairs are horizontal, please try CF-rule applies to $B$1:$AM$1:

Please Login or Register  to view this content.

If the pairs are vertical, please try CF-rule applies to $A$2:$A$39:

Please Login or Register  to view this content.

[komhs]

Am I doing something wrong with the formula?
Attachment 797180

[HansDouwe]

If i click at the link in the previous post I retrieved the message "Invalid attachment specified.".
Please could you attach your workbook? See yellow banner at the top of the page.

[komhs]

I think that I solved the previous problem and thank you for the Vertical. I have an issue with the horizontal though.
I want to choose from three options than two. Take a look at the attached file and especially the Sheet2.

Book1 HD.xlsx

[HansDouwe]

Please try CF-rule applies to $A$5:$C$21

Please Login or Register  to view this content.

If this solves your question, please consider adding reputation to the answers of all helpers that you think are worth the answer.
This can be done by clicking on * Add reputation at the bottom left of the answer(s)

[komhs]

Thank you again and again for the reply!
It is unpleasant to ask you again about something that you have already gave me
an answer for, but for some reason that I can't understand it doesn't apply to some columns.
Take a look at the file, if it doesn't irritate you.

Thank you in advance

algorithm_test_test.xlsx

[HansDouwe]

No, no problem. You have transferred the formula well, but because the intermediate cells are now emptied with a formula, the old one no longer works.
This one does work (both in the previous situation and in this new situation:

Please Login or Register  to view this content.

And thx for the rep. .

[komhs]

You' re welcome. The whole journey was very helpful. Thank you again