Conditional Colorization in Excel if a defined text is not exist.

Answer 1

Select the A column by clicking on the header. Then click the Conditional Formatting button on the ribbon and go to New Rule. Choose the option Format only cells that contain. You should be able to figure out the options from that point.

This might not sound much like a programming question, but I've found Excel to be fantastic for doing quick and dirty tasks that you thought might require a program.