In the past I created a complex named range via code and I wondered how I did it because I needed to do it again. I solved it when I realized that all I needed to do was to record a macro while creating it using Home->Conditional Formatting. Note that when you do that you get the code for all the worksheet's conditional formatting rules.