Dates Conditional Formatting - Microsoft Access Project Management


	Back to Access Project Management Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Dates Conditional Formatting

David Wilcox

5 years ago

Richard. I love the Project Management template. As you know, I'm an OAM (Official Access Moron) however I couldn't stop myself from purchasing the template. So being an OAM, I (obviously) have a question? Is there a way to use the 'dates' in the template labels (D00, D01, etc.) in a conditional formatting statement for Boxes 00 through 20, so that when that date coincides with another benchmark date I designate from my query? I've tried a couple of times, but I not sure if the "label" data is being recognized in the conditional statements. For example, when the data in Label D00 coincides with a benchmark date of 10/1 from my query, I'd like Box00 to change color. Can that be done? And if so, how? Thanks and live long and prosper.

	Richard Rost @Reply 5 years ago
Yeah... you could do it, but you wouldn't need conditional formatting. Since it's just a simple block of labels in the header, adjust their .BackColor manually. You'd need an event to check if the dates shown coincide with a benchmark date, which you'd need to designate somehow in your table. It's very possible.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Project Management.

Next Unseen

New Feature: Comment Live View