You can use conditional formatting to change certain properties of rows and cells according to specified conditions. You can modify the following properties in a cell:
- BackColor
- ForeColor
- TextAlignment
You can also have rules that apply to whole rows. You can adjust the following properties in a row:
- BackColor
- ForeColor
The conditions supported include:
- Equals
- Between
- Greater
- GreaterOrEqual
- Less
- LessOrEqual
- None
- NotBetween
- NotEqual
- StartsWith
- EndsWith
- Contains
- DoesNotContain