Thank you for the response KsT. I did go the macro route. A little background on the project, we are reviewing contracted items with data from an outside source. So as a line is verified 'good', it's highlighted green, if it's 'off', yellow for research. I could have, and may still add a new column to direct the conditional formatting, but this works well for now.