Creating rule-based conditional formats

Organizations of all kinds - whether they are corporations, charities, or social…clubs - need to keep track of how their group is doing.…Businesses set sales and profit goals, charities have fund raising targets, and…social groups often collect dues to pay for their get-togethers.…You can use conditional formats, which change a cell's appearance based on the…value it contains, to indicate how your results compared your targets.…A conditional format changes a cell's formatting based on the cell's value.…So, for example, let's say that the warehouse manager at Two Trees Olive Oil…wants to track the amount of storage space used in her warehouse, so she can…project whether ongoing production would bring in more cases than she could fit.…

She has decided to change her warehouse capacity's text to bold in any cell that…contains a value over 80%.…So I'm going to apply my conditional formats, and the first thing I will do is I…will select the cells to which I want to apply them, and then on the Home tab…