|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
|
Conditional Formatting By Richard Rost 
3 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? MembersMembers 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 files from class plus get access to the Code Vault. If you're not a member, Join Today!
Links
Keywordsmicrosoft 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
|
||||||||||||||||
|
| |||
| Keywords: TechHelp Access 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, c PermaLink Conditional Formatting in Microsoft Access |
