Learn how to use data validation and conditional formatting in Excel to set rules, create lists, prevent errors, highlight outliers, show trends, and visualize data.

Conditional formatting is a feature that sets various styling on cells/ranges based on their values. It is accessible via the ConditionalFormatting property of the ExcelWorksheet class or via ranges.

Conditional probability refers to the chances that some outcome (A) occurs given that another event (B) has already occurred. In probability, this is written as A given B, or as this formula: P(A ...

Type, Value Fill type, FillColor BorderType ... As of Epplus 7.0 full-support for Databars was added and the following properties can now be changed directly from Epplus using the DataBar conditional ...