On top of this, Excel ... you're done comparing the data, you can remove the conditional formatting by going to Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet.

IRR is an important tool for evaluating and comparing ... with an example. Suppose you have two potential investments with the following cash flows: Open MS Excel or Google Sheets.