Conditional Formatting for Multiple "Between" values

[wunderweasel]

I'm attempting to create a spreadsheet that imports .txt files from FedEx Ship Managerand then conditionally formats the zip code cells based on the ship zone they are in. Right now I have far too many conditional formatting scenarios and it causes excel to crash so I would like to simplify.

Here is an example of the Zip Code Zones:

77800 through 77899 = Zone 7 (Any Zip codes that fall between these two Zip codes will highlight blue)
77900 through 79599 = Zone 8 (Any Zip codes that fall between these two Zip codes will highlight green)
79600 through 80000 = Zone 7(Any Zip codes that fall between these two Zip codes will highlight blue)

There are over 100 of these ranges and I have a conditional format set for each one. Above I have 3 instances of a conditional format but I would like to know how to condense these to 2 as I have show below:

77800 through 77899, 79600 through 80000 = Zone 7 (Any Zip codes that fall between these two ranges of Zip codes will highlight blue)
77900 through 79599 = Zone 8 (Any Zip codes that fall between these two Zip codes highlight green).

Please halp!

 

[Peter_SSs]

Welcome to the MrExcel board!

77800 through 77899, 79600 through 80000 =

Not sure how you will go with so many conditions, but for the one above, try this CF formula

=OR(A1=MEDIAN(A1,77800,77899),A1=MEDIAN(A1,79600,80000))

 

[wunderweasel]

Welcome to the MrExcel board!

Not sure how you will go with so many conditions, but for the one above, try this CF formula

=OR(A1=MEDIAN(A1,77800,77899),A1=MEDIAN(A1,79600,80000))

Worked perfectly. Thank you!

 

[Peter_SSs]

Worked perfectly. Thank you!

You're welcome. Thanks for the follow-up.