Uhhh...Your IF statement doesn't have to be multiple ranges like that, because, so far, your range is 510250000 to 510252999, with no breaks between the ranges you listed! What's the logic behind what you want to do? So far, all we've seen is that your coloring cells, but why? What determines what color the cell is going to be? And what is the problem that your having? Is it performance related? RageInTheMachine9532