How do you highlight every 3rd column?

[billy2willy]

If I use conditional formatting to attempt to highlight every 3rd column on part of my spread sheet every 2nd and 3rd column get highlighted. The formula I came up with is =MOD(Column(),3). Can you help me?

[Domenic]

Assuming that A1:G10 contains your data...

1) Select your data, A1:G10

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:

=MOD(COLUMN(A1)-COLUMN($A$1),3)=0

4) Choose your formatting

5) Click Ok

Hope this helps!

[billy2willy]

Very good, thanks.