I see there was a late edit. Why use the slower VBA route when there's a perfectly efficient conditional format option?