2016-04-21_11h19_00.png

I need to create a formula or macro that will insert the word "Omit" in column B if the cell in column C is yellow. Is this possible? If it's easier to base it on text color instead of cell color, that can be arranged. The cells in column C are highlighted by conditional fomatting.

Any help you can provide is GREATLY appreciated!!

Kim