Border: change the cell border colour and border style.Fill: change the cell fill colour and fill pattern.You cannot change the font family, or font size.Font: show a different font style, or font colour, or add a strikethrough effect, or underline.You can apply the following formats with your rules: Change all cells in a row blue, if the number in column B is below 30.Change a cell's colour to red, if its value is below 50.Here are examples of those 2 types of rules: Usually, the rules are based on the contents of a cell - the formatted cell, OR a different cell. Set up the conditional formatting rule(s) for those cells.Select the cells that you want to format automatically. There are two steps for making conditional formatting work: That makes it easy to spot the months with low sales. With Excel conditional formatting, you can highlight one or cells, when specific conditions (rules) are met.įor example, you can set a conditional formatting rules for a column where the cells contain a number: More Conditional Formatting Examples What is Excel Conditional Formatting?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |