Friday, July 04, 2008
HOME

.NET Product Center SPREAD FOR .NET BUNDLE SPREAD FOR WINDOWS FORMS SPREAD FOR WEB FORMS INPUT PRO FOR WIN FORMS SUBSCRIPTIONS    SOA Center SPREAD FOR BIZTALK SERVER SPREAD FOR SHAREPOINT SERVER    COM Product Center DEVELOPER TOOLBOX DATABASE PACK SPREAD TAB PRO INPUT PRO LIST PRO CALENDAR OBJX BUTTON OBJX    Download Center TRIALS UPDATES    Purchase Center ORDER NOW GOVT / GSA LICENSE AGREEMENT WORLDWIDE RESELLERS CORPORATE DISCOUNTS WHY BUY?    Support Center TECHNICAL SUPPORT FORUM SUPPORT OPTIONS VIDEO LIBRARY SECTION 508 TRAINING CLASSES    Our Company CUSTOMERS SAY... ABOUT US CONTACT US JOB OPENINGS AWARDS CASE STUDIES WHY CHOOSE FARPOINT  FarPoint Technologies  (800) 645-5913  fpsales@fpoint.com

»Spread for Windows Forms » Product Tour » Conditional Formatting Conditional Formatting You can set up conditional formats within cells that determine the formatting of the cell based on the outcome of a conditional statement. You can use a named style to specify various formatting options such as borders and colors to apply if the condition statement is valid, that is, if the operation is satisfied. For example, you may want to change the background color of a cell based on the value of the cell. If the value is below 100 then the background color would be changed to red. The condition statement is "less than 100" and consists of a comparison operator "less than" and a condition, in this case a single constant "100". The condition can be a constant (expressed as a string) or an expression. Refer to the example below to see how to set conditional formatting for a range of cells that would result in different background colors, for instance, depending on the value in the cell.

Have a question? RSS Subscribe     Tour Home Annotation Mode Auto Complete Borders Cell Notes Cell Types Conditional Formatting Control Layer DataBinding Drag Drop DragFill Excel Compatibility Filtering Fonts/Colors Formulas Formula Textbox Freezing Rows/Columns Grouping Grouping Excel-like Hierarchy Import Export Merging Move Rows/Columns MultipleHeaders OperationModes Printing Printing to PDF Reporting Search Shapes Sheets Sorting Spans Spread Designer SubEditors Unbound Undo/Redo Viewports Zoom Rate this tour

Copyright © 1991-2007 FarPoint Technologies, Inc. All rights reserved. All names are property of their respective owners.