Formula for conditional format
On my master menu, I want some text to appear when there are incomplete shipping orders. I can conceive of using a trigger script that runs whenever the menu layout is entered, but I would imagine that would result in slowing the process of going to the master menu. So, I thought there might be a way of doing the check by using a table occurrence which matches Completed to a global field with a calculation of 1, and then use conditional formatting to hide or display the text. However I have been unable to do this. What is the best way to accomplish what I am trying to do with the least processing overhead?