>This highlights the entire column and not just one cell. Getting closer but not quite there. Thanks for all your input.
>
>David

Check your condition again. DynamicBackColor highlights only the cells which meet the specified criteria. If it highlights the whole column, there is something wrong with the condition. I can send you a sample where this code highlights exactly one cell.