1 of 1 people found this helpful
conditional formatting can have many 'formulas'.
Conditional formatting will go in the order set (first to last)
When you set multiple formatting conditions on an object, all conditions are evaluated starting from the top of the list. Each condition that evaluates “true” is appended to the objects previous format settings.
Thanks Beverly! That was helpful, my difficulty was the ultimate order each condition would fall in. I have now sorted it all out with your assistance.