Change color when matching a value in the cell

Hi All,


When I enter a specificed string into any cell of certain column (ex:C column), I want to have the following format:

1. Some cells that are the same row as that cell change to the specificed color
2. The current date will display automatically on respective cell

Thanks in advance,

Sub

Thanks for your answer. For your way, we can only create 3 optiones, so I want to build the code to do that.

Thanks again,

Sub

if you search this forum for condtional formating you will find that Bob Phillips has given some code on how to create in VBA conditional formatting with more than 3 criteria.

regards,
Simon