Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to chnage the cell background based on the value of precious cell.
For Eg: If cell1 > cell2 then green() else Red().
I have used background colour expressions based on the dimension values and cell value thresholds, but not by comparing two cells.
Please let me know if anybody has tried this already.
Thanks,
Shruthi Reddy
Yes, I got it working.
If the dimension is shown vertical then If( Above(Sum(Sales))> Sum(Sales), green(), Red())
If the dimension is shown horizontal If( Before(Sum(Sales))> Sum(Sales), green(), Red())
May be like:
If( Before(Sum(Sales))> Sum(Sales), green(), Red())
Yes, I got it working.
If the dimension is shown vertical then If( Above(Sum(Sales))> Sum(Sales), green(), Red())
If the dimension is shown horizontal If( Before(Sum(Sales))> Sum(Sales), green(), Red())