AnsweredAssumed Answered

Conditional formatting -

Question asked by btb01 on May 31, 2017
Latest reply on May 31, 2017 by BruceRobertson

Strange question here ...I am trying to format color of a text box.  Goal is to have box be one of 4 colors (Red, Yellow, Green, Blue)

I have the following conditional ..

Formula is NewWatchlist:: Priority "CL"      Fill Color

Formula is NewWatchlist:: Priority "P1"      Fill Color

Formula is NewWatchlist:: Priority "P2"      Fill Color

Formula is NewWatchlist:: Priority "P3"      Fill Color         

 

 

notes ....

     P1 and P3  work fine (it turns box either green or red.

     P2 and P4 don't work i have checked and double checked that the only difference is the variable (P1-P3, CL) ---

     Order does not matter (I have moved the batting order and no impact

 

 

any ideas?

thanks

Outcomes