I have been beating my brains out with this. I can't imagine this is too
hard, but I just cant make this work.

I have created a list of 100 items from S1 to S100 and named it "junk".
Cell F7 has a pull down list (DataVerificationListSource=junk) of these
items. I need to format F7 based on what item is selected. Items from
S1-S25 need to be red, S26-S50 blue, S51-S76 yellow, and S76-S100 no
formating.

Can anyone help me with this? Much thanks in advance.

Chris