Summary Sheet for Microsoft Office 97 – Word, Excel ...

This is the current table format before any conditional formatting rules. Now I will open up the Conditional Formatting Rules Manager and set rules that inform the spreadsheet that the B column will change the colour of the cells dependent on its text based values. ................
................