I think you should try to the AND and OR functions for conditional formatting might not be available in your version of the tool. Check if there an update or a different way to implement these functions by consulting the latest documentation or support from Ragic. You might also try combining multiple rules to achieve the desired effect if direct use of AND/OR isn’t possible.