Conditional formatting based on date

[DrPips]

Hi,

I have what is probably a simple problem, but I can't figure it out or find it on google.

I would like to format the cell that contains the date and the two next to it, based on the month of the date. I want 4 colour depending on the month so 1 colour for all dates January to March, a different colour for April to June, etc.

So if the date in A1 is January, it will format A1, B1 and C1. If that dates changes to September, it will change those 3 cells.

Any help much appreciated.

Thanks

 

[louisH]

Hi,

There might be an easier way to do that, but this is a solution :

Create 4 rules using these formulas with each a different color :

=OR(MONTH($A$1)=1, MONTH($A$1)=2, MONTH($A$1)=3) which applies to "=$A$1:$C$1"

=OR(MONTH($A$1)=4, MONTH($A$1)=5, MONTH($A$1)=6) which applies to "=$A$1:$C$1"

=OR(MONTH($A$1)=7, MONTH($A$1)=8, MONTH($A$1)=9) which applies to "=$A$1:$C$1"

=OR(MONTH($A$1)=10, MONTH($A$1)=11, MONTH($A$1)=12) which applies to "=$A$1:$C$1"