Pete - They are not consecutive.
How do I attach?
Pete....Great solution ...I will send a tip after you explain how to apply the rule to all rows with a 1 value
I see the if statment but can not get it to apply to the whole worksheet when I try to replicate your work.
I will tip