Conditional Formatting with a Goal

Is there a way to create a line and column chart where the color of the column is based on whether or not they met the dynamic goal, which is the line? The goal will change per person (column) based ...