Skip to Content
0
Former Member
Nov 11, 2008 at 10:52 AM

Background color

10 Views

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