If the date is a DateTime value (also has a precise time, e.g. Both min and max end-point values are included in the range.įor dates, use exact dates or relative dates to define a range. Can be used for numeric values, percentages, dates, or file sizes. Specify ranges of values that should have different formatting. If some other column in the report also has formatting, then conditions are merged in cells in this column (formatting from another column is applied if text, background, or font in this column has a default selection). Use the option Apply to all row cells to apply color/background/font style to all cells in a particular row. Also, there are several ways to define conditions : R ange, Exact value, Regular expression, Top/Bottom, and Heatmap. Select one of them. There are two ways how to apply those rules : you can set them on the values displayed in the cells or on the value calculated by a custom formula. You can set one or multiple rules, the first matching rule will be used. Specify one or several rules to detect cells that should have different text or background color, or use a bold font in the column or row. Select Cell formatting  from the column or row header, the table options.