(For the source code that creates this conditional formatting, see the Example below.) Conditional formatting rulesĬonditional formatting is expressed using formatting rules. Two of the rows have a value for age that matches the median age these cells receive no special formatting. Rows whose age is above the median have red text, and those below the median have a red background. In this example, cells in each row are formatted according to how the value in their age field compares to the median value of all the ages.
For example, you could format a range of cells based on their value compared to the median value of the range: You can even format cells based on their value with respect to that of other cells. Dynamically format cells based on the content of other cells (For example, highlighting the address of properties whose "time on market" field is > 90 days).Format cells so their color varies with their value (For example, applying a more intense red background as the amount over $2000 increases).Highlight cells above some threshold (For example, using bold text for all transactions over $2000).There are many possible applications of conditional formatting, including uses such as: Conditional formatting lets you format cells so that their appearance changes dynamically according to the value they contain, or to values in other cells.
0 kommentar(er)
