Conditional Formatting on an Access Form ~ DataPig
Channel: LearnAccessByCrystal
Date: 10/08/2022

Use conditional formatting to highlight specific values and records on a form in Access much like you would do in Excel. Using differences in some value in the records, one or more conditions can be highlighted by assigning a color to a condition. Records with the chosen condition are easily seen within the records based on the color. In this sample, unfilled Orders are highlighted in blue. An effective way to highlight records.

Here’s a related video:
Highlight Current Record in Access 
https://youtu.be/2ArtsDJrK7k

This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.