afi...@gmail.com
unread,Mar 10, 2014, 12:12:35 PM3/10/14You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hi
First time posting to the Group. Thanks for having this resource available.
I am trying to create a conditional format, turning the font red for a field, I want to test two fields at once for the condition to be true.
if(dateafter(promise_date,today()) < 2 and disposition = 'D', rgb(255,0,0),0)
This expression does not pass the Verify test.
How do you test two fields at once using the Conditional Formatting popup?
I could not find any examples in the Manual where multiple fields were tested in Conditional Formatting.
I'm familiar with CASE, can I use an "AND" in a CASE statement?
Thanks
Adam