---
title: "Conditional Formatting - Screen Forms"
canonical: "https://wiki.soft1.eu/space/SS5EN/234324073/Conditional%20Formatting%20-%20Screen%20Forms"
format: markdown
---
Find Conditional Formatting in  Screen Forms Design.  A wide range of formatting options that can be applied on Screen Forms fields/columns is available. The following walkthrough demonstrates how to design and apply conditional formatting in Screen Forms: Use background colors to highlight the lots'  Expiry date  (FINALDATE) from Stock Items> Screen Form >  Available lots  (Related job). At the example shown here, the expired lots are represented in red color, the soon-to-be-expired lots are represented in orange color, the not-expired lots (or not soon-to-be-expired ones) are represented in green color. See the walkthrough below on how to apply the above-described conditional formatting At Screen Form Design >  Available lots, right-click  on  Properties  (Lots grid) and select  Conditional Formatting .  Add red background color for expired lots  (see fig. 1). click  New Rule  and select the Rule Type:  Format only cells that contain , at  Format only cells with value  area select  less than  and= TODAY() ,  click  Format  for more options, for example, to set the red color for the specific period of time, click  ΟΚ  to add the rule, under  Applies to  area, select the FINALDATE field to apply the conditional formatting rule. Add orange background color for lots expiring in the next 7 days  (see fig. 2).  click  New Rule  and select the formatting rule type:  Format only cells that contain , at  Format only cells with value  area select  between , = TODAY()  and = TODAY()+7 click  Format  for more options, for example, to set the orange color for the specific period of time, click  ΟΚ  to add the formatting rule, under  Applies to  area, select the FINALDATE field to apply the conditional formatting rule. Add green background color for not-expired lots or lots not expiring in the next 7 days  (see fig. 3).  click  New Rule  and select the Rule Type:  Format only cells that contain , at  Format only cells with value  select  greater than  and= TODAY()+7 , click  Format  for more options, for example, to set the green color for the specific period of time, click  ΟΚ   to add the rule, under  Applies to  area, select the FINALDATE field to apply the conditional formatting rule. Click  Apply  to save the changes. Save the Screen Form Design too.