Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement of a table which will have conditional arrows in each row.
Example:
Let us consider a table with four columns:
Country, Previous Year Sale, Current Year Sale, Profit/Loss
US,10000,20000,XXX
UK,15000,10000,YYY
In place of 'XXX' there should be a green up arrow and in place of 'YYY' there should be a red down arrow.
The shades of the color will differ based on condition - from dark red for down arrow to dark green for up arrow.
I searched many forums but couldn't find any solution .
Any help on this is appreciated.
Hi! Use this expression for your Profit/Loss column: If([Current Year Sale]>[Previous Year Sale], '▲', '▼')
Then set color as expression as follows: If([Current Year Sale]>[Previous Year Sale], Green(), Red())
You can adapt the color condition based on your requirements.