Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

InfoMaker - conditional formatting using AND

11 views
Skip to first unread message

afi...@gmail.com

unread,
Mar 10, 2014, 12:12:35 PM3/10/14
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

afi...@gmail.com

unread,
Mar 11, 2014, 1:41:49 AM3/11/14
to
Figured it out...

if(daysafter(today(),promise_date) < -2 and disposition = 'D', rgb(255,0,0), 0)
0 new messages