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: