Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Gurus,
Please let me know how do I achieve this.
SPEND | 119000 | 90040 |
Budget | 100000 | 100000 |
Diff | [19000] | [9960] |
+19% | -10% |
•For spend
-Red if value exceeds budget, indicating overspend
-Green if value doesn’t exceed
Note:
Summary tab to show the percentage and actual values that exceed or below target.
Text and color coding should follow exactly like shown above.
Thanks a lot.
Regards
Vepuri
Hi!
Use cell text color expression:
If([SPEND]/[BUDGET]-1>0, Red(), Green())
Hi @Zhandos_Shotan ,,
I got the result earlier but not getting like.. as shown in the screenshot (Color Coding)
Thanks
Vepuri