8 Replies Latest reply: Oct 12, 2017 4:26 AM by Celambarasan Adhimulam

# Need Help on Color Coding as soon as possible

Hi ,

I have fileds lik this ,

My requirement is

Can anyoneplease help as it is very urgent for me

• ###### Re: Need Help on Color Coding as soon as possible

May be this?

If( [No of team managers] <2, Amber())

If([No of Member] =2, Amber(), If([No of Member] <2, Red())

Note - Amber() is not a direct color function. You can manipulate wit your RGB code

• ###### Re: Need Help on Color Coding as soon as possible

is there any possbility , can i keep in the table it self

• ###### Re: Need Help on Color Coding as soon as possible

Yes, You can use Text Color / BG color while expansion of expression ..

• ###### Re: Need Help on Color Coding as soon as possible

My requirement  is

if no of  team memers is 2,it should show yellow,

if no of  team memers is  greater than 2,normal black

if no of  team memers is  less  than 2,red

i need the text color

• ###### Re: Need Help on Color Coding as soon as possible

Yes, You can do something like below

If([no of  team memers]=2, Yellow(), If([no of  team memers] > 2, Black(), If([no of  team memers] <2, Red())))

• ###### Re: Need Help on Color Coding as soon as possible

hi

no luck

• ###### Re: Need Help on Color Coding as soon as possible

What formula is applied for [No of Members] ??

• ###### Re: Need Help on Color Coding as soon as possible

Hi Sahaja

You formula should be based on your expression name or your expression in the place of [MEMBERS]

Below exp is based on the Exp name

If([No of Members]=2, Yellow(), If([No of Members] > 2, Black(), If([No of Members] <2, Red())))

or

If(Sum([MEMBERS])=2, Yellow(), If(Sum([MEMBERS]) > 2, Black(), If(Sum([MEMBERS])<2, Red())))

Either way should work