This Excel spreadsheet uses conditional formatting to highlight the resistor pairs in a design that can create a particular ratio. The target ratio is entered in cell C3, and the tolerance is entered ...