I want to highlight a row in a table if the "Ready-to-ship Date" is Due (from Today), but I also want it to stop being highlighted if a "Shipping Date" has been selected.
i.e. The Ready-to-ship date is yesterday, so it shows a highlighted row, but say next week I finally manage to arrange the shipping date and from the moment I enter a Shipping Date the row on the table is NOT highlighted anymore. Suggestions?
If([Ready-to-ship Date]<Today() and
[Shipping Date] I*S* E*M*P*T*Y*,