Also we can create as many if statements as we want by clicking the Add rule button. Create a conditional formula that results in another calculation or in values other than TRUE or FALSE. Again open the menu Conditional Formatting New Rule.
A conditional formula in Excel is a formula that makes a logical test of data using the IF function.
Perform conditional calculations on ranges of cells. To get started open your worksheet in Excel and highlight the cells you want to format. The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions a function and a conditional format to display a daily balance in a revenue sheet. How do I copy an example.