How to use Conditional Formatting in Access

Conditional formatting is useful in an Access form to easily identify data values based on color or other cell formatting.  Here, I apply the conditional formatting on a datasheet form in an Access database and apply the validation on rows to show the display based on the meeting of certain criteria.

       1.First open the form in design mode, then select the field you want to apply conditional formatting.

                  

      

       2. Select the condition formatting option from the ribbon on the FORMAT tab.

              

      3.The Rules Manager window will now appear, and you will ADD / EDIT / DELETE conditional formatting rules.

                    

        4.After clicking on “Edit Rule”, this window will appear.

       5.Apply Conditions on Fields. Here I set the rule for the field when the value of the field [% Complete] is less than 100 then background gone to light blue.

           B: Here, I set the rule for the field when the value of the field [% Complete] value equals Cancelled, so that the background goes to light red.

          C: Here, I set the rule for the field when the value of the field [% Complete] is equal to 100% then background turns to light green.

         6.After apply the formatting on the field, copy the format using FORMAT PAINTER option and paste formatting to other fields.  

                 

  7.Select all and apply formatting on all fields.

         8.Here is the result: