Why not just apply the Conditional Formatting directly to column C? You can also use the macro recorder to capture to code and add it to your macro.