on 03-10-2014 8:52 PM
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?
This works in SQL but not in the Conditional Formatting popup.
Thanks
Adam
Solved it myself.
Issue wasn't the AND, it was the dateafter(). It was supposed to read daysafter().
AND works fine.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.