Background color

[Former Member]

Hi

I want to change background color of one field depending on condition.

i am using below formula in format_ border

f{Priority.RatingDescription1}='Excellent'

then

Lime

else

if {Priority.RatingDescription1}='Very Good'

then

yellow

else

if {Priority.RatingDescription1}='Good'

then

purple

else

if {Priority.RatingDescription1}='Fair'

then

aqua

else

if {Priority.RatingDescription1}='Poor'

then

red

else

if {Priority.RatingDescription1}='N/A'

then

fuchsia

but it is not working.

Please give me solution.

Thank you

[Former Member]

Hi

Now i placed the text in double quotes"".

No change.

I am not getting any eroor, but the background colors are not coming correctly.

for excellent it's working.

but for verygood, good, fair yellow color is coming.

in next record for verygood purple color is coming.

Thank you

[Former Member]

hi,

Add one more condition / else at the last and set the default colour. Then u can check wat ever conditional checkings are working.

Try setting background color like

if ({Abc.SubTotal}= true)

then

Color(220,220,220)

else

White

[Former Member]

Swetha,

Are you getting any error message? Can you make sure the field has those strings in them like

If ="Excellent" then

lime.

The field should contain "Excellent" string.

Additionally, the quotations should be " " and not ' ' .

Have you tried this option?

if GridRowColumnValue ("table.fieldname")="1"
then green

Regards

Jehanzeb