How to easily apply conditional formatting to every 2nd column and specific rows

[slam]

I have conditional formatting applied to E5:E200. I now need to apply it to the same rows in every second column G, I, K, M, and so on. I'm trying to do this with =MOD(COLUMN(),2)=0, but how do I fit the ROW range into this also?

Thanks!

 

[Joe4]

You would just include that in with your current Conditional Formatting formula:

=AND(your current formula,MOD(COLUMN(),2)=0)

 

[slam]

Hi Joe,

I think I broke it

I went from this (working on column E)

=AND(NOT(ISBLANK(A5)),E5<>D5)

.... to this (now column E not working))

=AND(NOT(ISBLANK(A5)),E5<>D5,MOD(COLUMN(),2)=0)

 

[Joe4]

If you want columns E, G, I, K, M, then you actually want the odd numbered columns, not the even ones (sorry, I just copied your original formula and didn't notice that your logic was faulty).

So your formula should be:

=AND(NOT(ISBLANK(A5)),E5<>D5,MOD(COLUMN(),2)=1)

Or you could use the ISODD function, i.e.

=AND(NOT(ISBLANK(A5)),E5<>D5,ISODD(COLUMN()))

 

[slam]

Perfect, thank you!

 

[Joe4]

You are welcome.
Glad I was able to help!