Search the Google Groups for "conditional formatting" vba, here:groups.google.com/advanced_group_search?q=group:*Excel*&num=100Let us know how you go with your code.