By Richard Rost 2 years ago
Use Conditional Formatting to Color Code Tasks
In this video, I will show you how to use conditional formatting in Microsoft Access to color code your task due dates. Tasks that are past due will show up red. Tasks due today will be yellow. Tasks not due yet (in the future) will be green. I'll also show you how to have the current field that has focus show up as bright yellow.
Amina from Kingston, Ontario, Canada (a Gold Member) asks: I have a list of tasks that I keep in Microsoft Access. Is there a way that I can color code them red for overdue, yellow for due today, and green for due in the future?
Members will learn how to use Expressions in conditional formatting to change the color of a field based on the value in another field. You can use this to change the color of an entire record (row) if you'd like.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, conditional formatting, field has focus, equals, not equals, future, past, expression is, based on another field, Highlight data, How to Highlight Records or Values, apply conditional formatting, forms, reports, Conditionally Formatting, conditional formatting based on another field, greyed out, not working, based on date
Subscribe to Conditional Formatting
Get notifications when this page is updated