I am working on color coding of a report where depending on certain comparison, the background color of the report should change. The condition is something given below:
if (x=0)
{
if (a>b)
{red color};
else if (a<b)
{green color}
else
{amber color}
}
else if(x=1)
{
if(a<b)
{green color}
else if(a>b)
{red color}
else
{amber color}
}
else if(x=2)
{ if ((a>b) and (c>d))
{red color}
else if ((a<b) and (c<d))
{green color}
else if ((a<b) or (c<d))
{amber color}
else
{blue color}
}
else
{blue color}
Can somebody please tell me how to implement this nested condition. I have tried the below option but it is not working. The loop never goes to default condition.
It would be difficult to troubleshoot without looking at a sample. Do you have a sample you can share with the expected output where each of the conditions can be tested out?
