Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Now we have the requirement , for the employees they have performance A/B/C,
if two or more performance are -1, like Frank as below then we set red background color;
if one performance is -1, like Tony as below then we set Yellow background color;
If all the performance is 1 like Emily as below then we set Green background color;
How can we write the expression for the requirement? Thanks in advance.
Haifeng
May be Like this
u can manipulate column itself
if(PA>0,1,-1),if(PB>0,1,-1),if(PC>0,1,-1)
then use
if(RangeAvg(PA,PB,PC)=1,green(),
if(Rangesum(PA,PB,PC)<= -2,red(),
Yellow()))
Thanks,
Priyanka
Thanks for your help.
But maybe have the performance -2,-3,2,34..etc in the future, its better to judge for performance <0 or >0, do you have any ideas? Thanks.
Haifeng
May be Like this
u can manipulate column itself
if(PA>0,1,-1),if(PB>0,1,-1),if(PC>0,1,-1)
then use
if(RangeAvg(PA,PB,PC)=1,green(),
if(Rangesum(PA,PB,PC)<= -2,red(),
Yellow()))
Thanks,
Priyanka