Conditional Format Formula for every 2nd column

[jl2509]

Hi Everyone.

I would really appreciate some support in trying to create a conditional format formula that highlights every value in every 2nd column i.e. B, D, F, H, J, and L where the value is lower than the required corresponding value in column A, C, E, G, I AND K as shown in the example.

Many thanks

Required	Total	Required	Total	Required	Total	Required	Total	Required	Total	Required	Total
5	3	5	1	5	2	5	1	5	3	5	4
5	3	5	5	5	1	5	2	5	4	5	2
5	0	5	5	5	0	5	3	5	3	5	5
5	0	5	1	5	1	5	5	5	0	5	5
5	0	5	5	5	1	5	0	5	0	5	0
5	5	5	3	5	5	5	0	5	5	5	5
5	0	5	2	5	4	5	3	5	3	5	3
5	3	5	4	5	1	5	0	5	5	5	3
5	4	5	3	5	1	5	3	5	3	5	0
5	3	5	4	5	0	5	0	5	0	5	4
5	4	5	4	5	5	5	1	5	1	5	1
5	3	5	4	5	4	5	0	5	4	5	0
5	2	5	0	5	0	5	0	5	2	5	1

 

[Joe4]

Assuming that your data begins in cell A1, select the range starting in cell B2 down to the last cell in your range.
Then, go to Conditional Formatting, and choose the formula option and enter this Conditional Formatting formula:

=AND(ISEVEN(COLUMN()),B2<A2)

and then select your red font formatting option.

Result:

 

[jl2509]

Thanks for the response and awesome solution.
Very much appreciated

 

[Joe4]

You are welcome.
Glad I was able to help!