How to Update Conditional Formatting in Excel 2007

1. Highlight the cells with the conditional format you want to change. To make changes throughout the worksheet, highlight the entire spreadsheet by pressing 'Ctrl' and 'A' at the same time.
2. Click the 'Home' tab in the Office Ribbon and select 'Conditional formatting' from the 'Styles' box.
3. Select 'Manage rules' from the menu that appears. This opens the conditional formatting rules manager dialog box.
4. Click on the rule you want to change.
5. Click 'Edit rule' and select from the dialog box options to update your conditional formatting.
6. Click 'Ok' to save your change, then click 'Apply' to apply the rule to the spreadsheet.
7. Click the next rule and repeat the 'Edit rule' and saving processes.
8. Click 'Ok' to save all changes and close out of the conditional formatting rules manager when you are finished.