While the tab is selected, the color will have a light gradient color. When the tab is no longer active, the color will turn solid. (See the screenshot below of a workbook with colored tabs.) You can ...

See the screenshot below. To color-code specific text, select the cells that contain (or will contain) the text that you want color-coded. In the example above, I have selected cells B2:B27. At this ...