Colour Code New Month

[Busymanjohn]

Hi guys, little poser for you. If using a file that contains monthly data say starts at Jan and we wanted to colour a column every time a new month was added what is the best way to achieve this?

 

[keymaster]

What do you mean by colour a column? If you want to change the background color of a column when first row has a month-name, you can do this with conditional formatting.


Just select the columns, go to CF, add rule

Use rule type as formula,

write something like,

=A$1<>""

and then set the color in formatting

 

[Hui]

BusyManJohn

I'd try applying Conditional Formatting to the columns

Use a formula like =mod(column(),2)=1 and apply a color

This will give you vertical zebra stripes of the color you choose