This feature helps end-users to quickly notice critical information, identify trends and exceptions, and compare data. ' Apply bold font weight to cells in a 'Salaries' column which have top 10 values. The DevExpress ASP.NET MVC GridView supports conditional formatting, i.e., automatically applies cell formatting based on the specified rules. = SpreadsheetColor.FromName(ColorName.Red) ("E2:E" & (rowCount + 1), ContainDateOperator.Yesterday). ' Apply red shading to cells in a 'Deadlines' column which are equal to yesterday's date. (MultipleBorders.Outside, SpreadsheetColor.FromName(ColorName.Red), LineStyle.Double) ("B2:B" & (rowCount + 1), ContainTextOperator.Contains, "Doe"). ' Apply double red border to cells in a 'Names' column which contain text 'Doe'. = SpreadsheetColor.FromName(ColorName.Green) ("C2:C" & (rowCount + 1), ContainValueOperator.Between, 15, 20). ' Apply green font color to cells in a 'Years of Service' column which have values between 15 and 20.
("C2:C" & (rowCount + 1)).IconStyle = SpreadsheetIconStyle.FourTrafficLights ' Apply 'Icon Set' conditional formatting to 'Years of Service' column. ' Apply 'Data Bar' conditional formatting to 'Salaries' column. ' Apply '3-Color Scale' conditional formatting to 'Salaries' column. ' Apply '2-Color Scale' conditional formatting to 'Years of Service' column. = SpreadsheetColor.FromName(ColorName.Accent5Lighter80Pct) = SpreadsheetColor.FromName(ColorName.Accent1Lighter40Pct) ' Apply shading to alternate rows in a worksheet using 'Formula' based conditional formatting.
Var worksheet = ("Conditional Formatting") SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")
Outlook conditional formatting on source code serial key#
If using Professional version, put your serial key below.
0 kommentar(er)
