</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle"></div> <div id="PageTitle"><div id="PageTitleText">Adding Conditional Formatting</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="WelcmPg.html">Welcome to LightSwitch Desktop Edition</a> > <a href="FlxOvrvw.html">FlexGrid for LightSwitch Overview</a> > <a href="CustmzngAppearnc.html">Customizing the C1FlexGrid Appearance</a> > Adding Conditional Formatting</td></tr></table></div> <div id="BodyContent"> <p>The <b>C1FlexGrid</b> control includes properties that conditionalize the foreground and background colors of specific values (numbers, dates, times, etc.) This will make specific values, and/or dates and times, stand out on your grid.</p> <p>To set these properties, select <b>FlexGrid Numeric Column</b> or <b>FlexGrid DateTime</b> <b>Column</b> from the drop-down next to the appropriate field and view the <b>Advanced</b> group</p> <p>Other kinds of conditional formatting (specific ranges, multiple colors) can be achieved in code. See <a href="Programming.html">Programming FlexGrid for LightSwitch</a>.</p> <p><strong>Specifying Conditional Formatting for Numeric Values</strong> </p> <p>You can customize how specific numeric values are emphasized using the <b>Advanced</b> group of the <b>FlexGrid Numeric Column</b> element. Foreground and background colors for specific values can be set, and/or the text may be bolded.</p> <p>Enter a value in the <b>High Value</b> field and choose the color(s) you wish, and bold text if desired. Cells that are greater than this value are formatted with the specified color/bold attributes.</p> <p>Enter a <b>Low Value</b> and make your selection. Cells that are less than this value are formatted with the specified color/bold attributes.</p> <p><img border="0" alt="" src="images/Images_Used/FlexGrid/image132_8.png"></p> <p><strong>Specifying Conditional Formatting for Date and Time Values</strong> </p> <p>You can customize how specific date and time values are emphasized using the <b>Advanced</b> group of the <b>FlexGrid TimeDate Column</b> element. Foreground and background colors for specific values can be set, and/or the text may be bolded.</p> <p>Choose an option in the Format Dates field and choose the color(s) you wish, and bold text if desired. Cells that meet these criteria are formatted with the specified color/bold attributes.</p> <p>Following are the available options for the <b>Format Dates</b> property:</p> <ul> <li>None</li> <li>Yesterday</li> <li>Today</li> <li>Tomorrow</li> <li>Last Week</li> <li>This Week </li> <li>Next Week</li> <li>Last Month</li> <li>This Month</li> <li>Next Month</li> </ul> <p><img border="0" alt="" src="images/Images_Used/FlexGrid/image132_9.png"></p> <p><strong>Specifying Conditional Formatting for Text and Choice Columns</strong></p> <p>You can customize how specific values are emphasized using the <b>Advanced</b> group of the <b>FlexGrid Text Column</b> element (and also <b>FlexGrid Choice</b> <b>Column</b>) element. Foreground and background colors for specific values can be set, and/or the text may be bolded.</p> <p>Following are the available options for the <b>Format Condition</b> property:</p> <ul> <li>None</li> <li>Equals</li> <li>Does Not Equal</li> <li>Contains</li> <li>Does Not Contain</li> <li>Begins With</li> <li>Ends With</li> </ul> <p>The <b>Value</b> property is used in conjunction with the <b>Format Condition</b> property to specify the condition. Cells that satisfy the condition are formatted with the specified color/bold attributes.</p> <p><img border="0" alt="" src="images/Images_Used/FlexGrid/image132_10.png"></p> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a href="http://our.componentone.com/groups/" target="_blank">Product Support Forum</a> | <a href="http://feedback.componentone.com/forums/255782-winforms-documentation" target="_blank">Documentation Feedback</a> </div> </body> </html>