Excel: Conditional Formatting on Text

Conditional Formatting is an excellent method for highlighting the Text in a spreadsheet. Each word or phrase can have different formatting for the Font and Cell Fill. This sample spreadsheet has three products: Legs, Eggs, and Pigs that are sold each day. The goal is to format each product with a different color.

Here is a YouTube video that shows more options:

Microsoft Excel 2013 Advanced: Tables Work for Me!

Please evaluate my Courses: Visit our school at UDEMY