Watch this tutorial to learn how to update the colors in an Excel spreadsheet using conditional formatting rules:
Check out the tutorial above.