Re: Conditional formatting issues

marktienzo — Mon, 04 Feb 2013 03:04:21 GMT

Good day surly0k,

I noticed that you used is not equal to and on your question you like it to be equal to R or C. Try using RAG is equal to C OR RAG is equal to R, if this is what your aiming for.

Conditional formatting issues

surly0k — Tue, 07 Aug 2012 17:22:27 GMT

Hello there Wizards and Gurus!

THis is my issue. I have a project management form. I have 3 fields that my question concerns. Original End Date(OrigED), Adjusted End Date(AdjED) and Rag Status(RAG) which has values of red amber green and closed. (R A G C), The functionality I am ultimately looking for is if OrigED and AdjED have both passed, then RAG Status must equal EITHER C or R. I can make it work when RAG is equal to c, or I can make it work when RAG is equal to R, but not when it is EITHER C or R. Is this some funky infopath rule? This is what I'm working with now in the data vaidation window:

If OrigED is less than or equal to today() AND

AdjED is less than or equal totoday() AND

RAG is not equal to C

I would think all I should have to add is another OR statement:

Rag is not equal to R

But this doesn't work. any ideas?

General

Re: Conditional formatting issues

Conditional formatting issues