Skip to Content
0
Former Member
Jul 10, 2008 at 01:11 PM

Condotional color formatting

26 Views

I am trying to conditionaly format any alpha data field in a table that contains the text [Release] and anything that follows, the formula I am using is,

if ({INCIDENT.CALLBACK_RMK}) >= '[Release]'
then crRed

The problem I am having is that the formula colors all alpha data in that field regardless if it contains [Release]. I have also tried the comparisons =, and > alone, 
I have also tried double quotes around [Release]. Any assistance will be greatly appreciated!

sorry for all the code tags the forum is changing my text with the square brackets.

Edited by: Louis Sindoni on Jul 10, 2008 3:13 PM

Edited by: Louis Sindoni on Jul 10, 2008 3:15 PM