I will then choose a red color. Click OK. Repeat the same steps for the remaining company types and choose the preferred formatting. See the screenshot below for my color-coded spreadsheet. Note that ...