AnsweredAssumed Answered

Conditional Formating...

Question asked by netguykb on Dec 9, 2008
Latest reply on Dec 9, 2008 by TSGal

Title

Conditional Formating...

Post

I am trying to create Conditional Formatting between Two Fields

Activities::dateDue < Get (CurrentDate) AND Activities::outcomeStatus = ("Followup Call" OR "Followup E-Mail" OR "Initial Call" OR "Initial E-Mail" )

Then display font color as RED + BOLD for the following related fields

Activities::dateDue
Activities::outcomeStatus
Activities::assignedTo
Activities::subject
etc...

 

My first attempt was to assign conditional formatting on Activities::dateDue and then Simply apply the change in color and bold for just this one field, as o to test my theory:

 

Condition = Formula is
Case (
Activities::activity_date_due  =  Get (CurrentDate) ; TextColor ( Activities::activity_date_due ; RGB ( 0 ; 102 ; 0 ) ) ;
Activities::activity_date_due < Get (CurrentDate) ; TextColor ( Activities::activity_date_due ; RGB ( 0 ; 255 ; 204 ) ) ;
Activities::activity_date_due > Get (CurrentDate) ; TextColor ( Activities::activity_date_due ; RGB ( 0 ; 0 ; 0 ) )
)

 









Outcomes