Conditional formatting is an Excel feature you can use when you want to format cells based on their content. For example, you can have a cell turn red when it contains a number lower than 100. But how do you highlight an entire row?
If you?ve never used Conditional Formatting before, you might want to look at Using Conditional Cell Formatting in Excel 2007. It?s one version back, but the interface really hasn?t changed much.
But what if you wanted to highlight other cells based on a cell?s value? The screenshot above shows some codenames used for Ubuntu distributions. One of these is made up; when I entered ?No? in the ?Really? column, the entire row got different background and font colors. To see how this was done, read on.
HTG Explains: How Does Email Work? | How To Make a Youtube Video Into an Animated GIF | HTG Explains: What Are Character Encodings and How Do They Differ? |
没有评论:
发表评论