Alternating row colour according to month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah (OGI) - 17 May 2007 12:55 GMT

I have a list of dates, in ascending order.
I'd like to be able to alternate the cell colour according to month, i.e.
all Jan dates need to be blue, all Feb dates need to remain white, all March
dates need to be blue, all April dates need to remain white, and so on.
I'm thinking this is some sort of conditional formatting?
Any ideas?

Reply to this Message

JLatham - 17 May 2007 13:09 GMT

Select the cells you need to shade and use conditional formatting. Assuming
for this example that your dates are in column A and begin at A1, choose the
Formula Is option in conditional formatting and enter a formula like this:
=MOD(MONTH($A1),2)=1
and set the format. This will set shading for cells when it is an odd
numbered month, as Jan, Mar, May...November. If you use
=MOD(MONTH($A1),2)=0
the the even numbered months would be shaded.

> I have a list of dates, in ascending order.
> I'd like to be able to alternate the cell colour according to month, i.e.
> all Jan dates need to be blue, all Feb dates need to remain white, all March
> dates need to be blue, all April dates need to remain white, and so on.
> I'm thinking this is some sort of conditional formatting?
> Any ideas?

Reply to this Message

David Biddulph - 17 May 2007 13:11 GMT

Yes. Format/ Conditional formatting/ Formula is: =MOD(MONTH(A1),2)=1
and choose your blue format.

Signature

David Biddulph

>I have a list of dates, in ascending order.
> I'd like to be able to alternate the cell colour according to month, i.e.
[quoted text clipped - 3 lines]
> I'm thinking this is some sort of conditional formatting?
> Any ideas?

Reply to this Message