Conditional Formatting Month

[matey56]

Hi,
I have a form that pulls a date from a query in the 2/23/2022 format and displays it as Feb-22 in the form. Is there a way to use conditional formatting to color code each month in that control? In other words, if Feb it's red, March it's blue, April it's green, etc.?

[pbaldy]

You could use the Month() function with your field. An expression like:

Month([FieldName]) = 1

[matey56]

You could use the Month() function with your field. An expression like:

Month([FieldName]) = 1

Worked like a charm. Thanks!

[pbaldy]

Happy to help!

[matey56]

One more question actually....so the month formula colors the date cell that I want. What if I want to also have it color the adjacent cell the same color? What do I need to do?

[pbaldy]

The same expression should work in those textboxes. You can select multiple textboxes and apply the same conditional format to all.

An alternative is a single textbox behind all the others with the conditional format, and if memory serves the textboxes on top have their back style set to transparent.

[matey56]

The same expression should work in those textboxes. You can select multiple textboxes and apply the same conditional format to all.

An alternative is a single textbox behind all the others with the conditional format, and if memory serves the textboxes on top have their back style set to transparent.

Awesome, it worked. I should have known that.