Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Video Use Formulas To Apply Conditional. Also learn how to apply new rules to your Excel sheetDont forget to check out. Then to use a formula select the last option.
Then to use a formula select the last option. In the Style box click Classic. Start off by selecting the cells you want to format and then select New Rule from the Conditional Formatting menu on the home tab of the ribbon.
Our formula will be comparing the values in the in stock column to those in the reorder column.
After that go to Home Tab Styles Conditional Formatting New Rule Use a formula to determine which cell to format. Also learn how to apply new rules to your Excel sheetDont forget to check out. In this example I am going to format the cells in the Product column if the corresponding cell in the In stock column is greater than 300. Formulas are the gateway to more powerful and flexible conditional formats.