Set colour according to month

[plchri]

Hello,

Hope someone can help with this one!

I have a simple Prospects list, where I have an 'Expected Date' field (Date), which is set to just show month and year.

How would I setup the conditional formatting to set the colour of this 'Expected Date' field according to the 'current month', 'next month' and 'month after next' basically to give you:

Current month = Colour 1

Next month = Colour 2

Month after next = Colour 3

 

Cheers

Peter

[comment]

How about this way?

Note that the conditions are mutually exclusive, so the order does not matter.

[plchri]

Not sure if my reply was registered, so here again: Thank you very much, it was perfect!

Best regards

peter